Tagged Questions
0
votes
1answer
22 views
Database MSDB can not be opened
I have got this problem in local instance of SQL Server 2008 R2 on my machine. There are several databases on this instance. But I am not able to see any of them from the object explorer.
I am able ...
0
votes
0answers
187 views
SQL Server 2008R2 Management Studio Script Will Delete rows correctly, but same delete doesn't work in stored procedure?
I have a delete statement that will run correctly in management studio but the exact same statement will not run correctly from within a SPROC.
delete from
DB1.dbo.Table1
from
...
0
votes
1answer
32 views
Is it possible to create permanent object aliases
I recently found myself using some rather lengthy names for the tables and views involved in a development piece, which got me wondering whether it's possible to create client/database/server level ...
0
votes
2answers
218 views
SQL insert data into a brand new column fails
I'm using a script like the following, but it keeps complaining of an Invalid column name 'NewColumnA' . Is dynamic sql necessary to accomplish this, or is there an easier solution?
ALTER TABLE ...
0
votes
1answer
104 views
How do I tell SSMS *not* to debug every query? [closed]
In trying to use SQL Server Management Studio 2008 R2, every query I run gives this error message:
Failed to start debugger. EXECUTE permission was denied on the object sp_enable_sql_debug, database ...
0
votes
1answer
192 views
Sql server 2008:Permission to access database properties
What is the minimum permission(server roles and user mapping) by which properties of database can be viewed in sql server 2008?
Now i hav given only public and datareader in user mappings and public ...
1
vote
1answer
221 views
regular expression - change to camel case / remove underscore
I want to convert all the strings in my notepad/Sql Server management studio into camel case and remove all the underscores.
E.g.:
string a = REFERENCE_DATA_ID
String b = ReferenceDataId
I want to ...
0
votes
1answer
154 views
How to test a query against a stored procedure
-- =============================================
ALTER PROCEDURE [dbo].[NST_GetCboCurrencyAfterUpdate]
@AccCurrency nvarchar(3)='',
@AccSgroup nvarchar(6)= '',
@AccInternalCie int=null
AS
BEGIN
...
2
votes
0answers
79 views
Is there a way to set defaults for generate scripts in SQL Server 2008?
Most of the time when I generate script in SSMS, I have to changed the exact same number of settings in the Generate and Publish Scripts wizard. Is there a way to set the defaults in this wizard ...
2
votes
1answer
131 views
SSMS: Separating blocks of comments while collapsed
Is there a way in SSMS editor to visually separate two comment blocks that are placed one right after another when the comments are collapsed?
Please look at the link below - remember that this code ...
2
votes
1answer
30 views
Is there a way to not have Intellisense default to “on” in a new query window in SSMS?
I'm using SSMS (v10.50.2500.0) against a SQL Server 2008 R2 database. I have SQL Prompt installed and am tired of getting incorrectly red-lined by the built-in SSMS Intellisense whenever I open a new ...
0
votes
1answer
626 views
SQL Studio Management - How to run queries across multiple servers
My 2 server both use SQL Server 2008 R2
I have my local SQL server and also an Amazon machine running an instance of SQL-Server there.
I'm able to connect from my local machine to that Amazon SQL ...
0
votes
0answers
48 views
SQL Server Management Studio Unexpected results
If I compile the Storedprocedure in Tab1, and If I'm executing the SP by giving the parameter in Tab2 in same SSMS, the results are totally unexpected.
I'm login into SSMS by Windows ...
0
votes
1answer
190 views
Invalid Column Name When Open To Edit A Table
I'm running SQL 2008 R2. I added 3 columns to an existing table. There was not any problem. Then I opened the table to edit with right click ("edit top 200 rows"). When I write a value to the new ...
0
votes
3answers
507 views
SQL Server Agent Job Completion E-mail Notification
I've created a Database Mail account (tested and sends with no problem), created an operator, set up an alert on the job I want to monitor, and restarted my SQL Server Agent. But I still am not ...
