SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.
4
votes
1answer
2k views
How to apply a theme to SQL Server Management Studio 2008?
Has anyone had any success with, for example, applying a 'dark' them to the Text Editor component of of SSMS 2008?
There was an old trick for 2005 which is no longer operational and has not been ...
23
votes
7answers
5k views
Why should I use Visual Studio 2010 over SSMS for my database development?
Visual Studio 2010 introduces database projects and a whole array of related features that supposedly facilitate database development. I've used SQL Server Management Studio (SSMS) for many years to ...
10
votes
6answers
634 views
Did anybody use sqlcmd mode in practice? [closed]
SQLServer 2005 introduced something called SQLCMD Mode msdn link.
At first glance this mode adds variable subsitution from command line batch files, and some escaping to OS commands.
Is this ...
14
votes
1answer
299 views
Poor SQL Server performance when management studio closed
I've noticed a strange behaviour of SQL Server 2008 r2 express:
usually my query execution time is ~650ms, but if I open Management Studio and run any simple query (for example SELECT * FROM ...
0
votes
1answer
50 views
Start Windows Service If Replication Fails
Setup:
We have SQL Server Management Studio 2005 SP3 on all of our Servers.
We have 1 Main Server, and 1 Secondary Server that has the database from the Main Server being replicated on it. (If it ...
1
vote
1answer
322 views
Why is my maintenance plan save overwriting job ownership?
I'm slowly untying all the system dependencies to the previous DBA's system account and moving them to a service account. The old DBA had ownership of all the jobs in our maintenance plan. In SSMS I ...
2
votes
1answer
136 views
Why evaluates “IS NULL” in SSMS interactive mode to “TRUE” but the same statement being executed in a SP to “FALSE”? [closed]
Given
DECLARE @IN__CUST_NO INT
DECLARE @OUT__USER_ID INT
SET @IN__CUST_NO = 1000006660
CASE 1: IS NULL evaluates TRUE
Since no CUSTOMER_NUMBER with the value of 1000006660 exists in our dummy ...
-5
votes
1answer
496 views
Where will i download denali SSMS from? [closed]
I have read many blogs around praising new features in denali SSMS. I really wanna try but unable to find how to download only SSMS (denali).
3
votes
2answers
207 views
SQL Server Configuration Manager changes effected via Central Management Server
When using Central Management Server (CMS), under Central Management Server Actions, SQL Server Configuration Manager (SSCM) is an option.
When launched, the GUI reflects the information of the ...
11
votes
3answers
775 views
Is it OK to blindly add missing indexes?
I often use SSMS to test my slow stored procedures for missing indexes. Whenever I see a "Missing Index (Inpact xxx)" my kneejerk reaction is to just create the new index. This results in a faster ...
0
votes
2answers
273 views
How database users see their objects in sql server
I have a large database in Sql Server 2008 that has many Tables , Stored Procedure, Functions.this database has several users.what can I do for Users that each user after connect to Managment Studio ...
3
votes
2answers
447 views
sql server management studio 2008 sucks up with memory yielding .net runtime failure
PROBLEM
sql server management studio 2008 sucks up with memory yielding a .net runtime error. It crashes with an empty message in an error-dialog but there can be found a little eventlog entry, ...
8
votes
1answer
316 views
How to get accurate query performance?
I'm attempting to improve performance of a stored procedure. When I run the SP, it finishes almost instantly, as if something were cached. I was told to use the following two lines of SQL before ...
4
votes
4answers
1k views
When to add indexes to #temp tables?
When testing stored procedures in SSMS, it sometimes says there is a missing index on
#someTempTable____________________000000000000005B] (someField) etc etc
When I do add them like this to the sp:
...
1
vote
1answer
1k views
Why are breakpoints not being hit in SQL Server Management Studio?
SQL Server Management Studio allows debugging of SQL (breakpoints and stepping through the SQL). It is possible to step in to a stored proc being called and to see a call stack. However I cannot ...
10
votes
1answer
2k views
How do I read Query Cost, and is it always a percentage?
I'm currently studying for SQL 70-433 (the Microsoft Certification exam), and I'm getting very confused about the "query cost" performance metric.
According to any documentation I could find via ...
1
vote
1answer
86 views
Migrate Data and/or Schema from DBv1 to DBv2
I have a production database which has been plugging away for several months. I have been making modifications to a duplicate copy on a test/dev server. I've added some additional fields (null ...
0
votes
2answers
140 views
Cant connect to Server using SSMS on my desktop
SQL SERVER 2008 R2
When attempting to connect to the default instance of sqlserver on our local server from SSMS on my desktop I'm receiving the following error.
A network-related or ...
1
vote
1answer
580 views
Meaning of SSMS database icon preceded by scroll with red x
SSMS 2008 R2, connecting to a 2008 instance shows the above glyph in SSMS Object Explorer. None of our other instances show that icon. I've moused over it in the vain hopes that I'd get a useful ...
4
votes
1answer
182 views
Does Management Studio let me change the format of new script names?
I use SQL Server Mangagement Studio to examine the definition of objects in my database.
For example, to examine the definition of the table dbo.MSreplication_options in the master database, I would ...
3
votes
1answer
505 views
Connecting from SSMS to an EC2 SQL Instance
I have an EC2 server running SQL2008 R2.
I opened the port 1433 and successfully tested with yougetsignal.com/tools/open-ports.
I have set the SQL Server to Accept Remote Connections.
I have set ...
5
votes
2answers
133 views
Is is possible to manage SQL Server 2008 databases via R2 Management Studio?
Is it possible to manage SQL Server 2008 databases using SQL Server 2008 R2 Management Studio?
1
vote
2answers
389 views
Are there any reasons not enable SQLCMD-mode as default in SSMS?
I don't consider "just to ensure that sqlcmd-mode is not required by a script" a valid reason.
Any things to think of before giving the order to enable this setting to my coworkers?
1
vote
1answer
162 views
Enable SSMS in SQL Server 2005 Developer Edition
We just had an upgrade of all our computers here, and on one of them we loaded our licensed copy of Visual Studio 2008 and SQL Server 2005 Developer edition. I then loaded the service packs (4 for ...
2
votes
2answers
673 views
Why is query using Clustered Index when it shouldn't?
Let us presume I have a table named Category in a SQL Server 2005 database. Category has category_id (bigint, identity) as its primary key and name (nvarchar(50)). There is obviously a clustered ...
4
votes
1answer
789 views
Where are Full-Text indexes in SSMS 2008 R2
I created a new database, a few tables, and full-text index & catalog using SQL Server Management Studio without any problem. I wanted to copy the T-SQL creation scripts for each of those to ...
2
votes
2answers
585 views
Recent Queries in SQL Server 2005
I'm using a PHP web application to interact with a database and need to catch an erroneous query. It's dynamically generated SQL and I don't know 100% of the code nor did I write it so I need to see ...
2
votes
3answers
782 views
Why is SSMS inserting new rows at the top of a table not the bottom?
Whenever I manually insert a row into a table in SQL Server Management Studio 2008 (the database is SQL Server 2005) my new row appears at the TOP of the list rather than the bottom. I'm using ...
2
votes
4answers
962 views
how to turn off delimiters in generated SQL scripts for data types in SQL Server Management Studio
We are a software engineering firm. We use SQL Server Management Studio (SSMS) to generate the few scripts we need to build and upgrade our databases.
While it does an OK job, it bugs me that it ...
5
votes
2answers
732 views
Sql Server Management Studio for 2008 Express?
I just installed Win7 on a fresh laptop and want to put a lightweight MS Sql Sever on it. VS2010 already installed SS2008 Express. So now I just need a management studio for it.
What would you ...
3
votes
2answers
745 views
SQL Server query result transfer time over VPN (WAN)
I have a mysterious phenomenon on one remote SQL Server 2005 which I manage and query using SQL Server Management Studio. I connect to the server through a VPN tunnel (provided by an ISP, about 8 ...
2
votes
2answers
1k views
Problem Reaching VM SQL Server Instance
Here's what I'm working with right now. I have a host OS which includes a SQL Server 2008 Enterprise instance. I have a virtual machine running on this host which has a SQL Server 2008 R2 Express ...
1
vote
3answers
649 views
Is it possible to install a MS SQL Express Studio, where the studio tool also is included?
I am facing the following problem:
I want to have a Express (=free) version of MS SQL Server and there I want to be able to see the SQL Management Studio interface. I have found only installations ...
3
votes
1answer
74 views
How do you move a Database from one server to the other using MS-SQL-SMS
I need to move a database, but I want to make sure I do it safely and with all triggers, store proc and functions.
I was think to simply detach the database from my server using MS-SQL-SMS and move ...
6
votes
3answers
2k views
Specify Connection in Management Studio T-SQL Query
When adding users are roles to DB servers I often use the "Script this action" function from the GUI. I then just go to "Connection :: Change Connection" to do the same on my other servers.
Is there ...
1
vote
1answer
935 views
Recovering from: A transport-level error has occurred when sending the request to the server in SSMS
Every now and than I loss the connection in SSMS and get the message
Msg 121, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP ...
2
votes
1answer
134 views
Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?
Just as the question says.
I have scripts with 3 different encodings and feel offended by having to manually select of about 200 possibles I was never interested in. ( I didn't count them ).
9
votes
4answers
3k views
SQL Server Management Studio for a remote database
With a SQL Sever database which is on a remote hosted dedicated server I can work using SQL Server Management Studio installed either on the same server or on my local computer. I the first case I ...
