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.
3
votes
1answer
43 views
How can I rename an auto-named constraint when I get this error 15248?
Method:
Open SSMS. Find table. Open constraints. Find constraint name. Right click, rename. Give new name.
EXPLODE. (well, it just fails, at least)
3
votes
1answer
216 views
How to check connection string in SSMS2012?
I'm connected to database. I use db by Management Studio 2012 Express. Can I check connection string by click something in Management Studio?
3
votes
2answers
449 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, ...
3
votes
1answer
506 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 ...
3
votes
1answer
371 views
Running queries with SQLCMD vs. Running queries with SSMS
I've noticed something which i'm not sure about. can it be that running queries directly with SSMS is much faster than running queries with SQLCMD? I've noticed that the results of queries that ran ...
3
votes
2answers
751 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 ...
3
votes
1answer
549 views
Management Studio all buttons disabled
I get an odd problem in my SQL R2.
Although I can attach a new db to my db instance, but all buttons on the tool menu panel are disabled.
So I cannot execute any sql query statements.
It is really ...
3
votes
1answer
52 views
Save SSMS tabs with timestamp on a daily basis?
Is there a way to automate SSMS to automatically save down all current open tabs into a folder with a timestamp?
Whilst I'd like to save every single useful ad-hoc query ever written with a nice ...
3
votes
1answer
171 views
Odd SQL Server Studio error, but not on SQL Server Express?
I'm running a query that I got today from a previous question, and I just noticed an error that only happens when I run this query ON the server (RDC + MS Studio -- not express) vs on my machine which ...
3
votes
1answer
544 views
Removing Instances and SQL Server Express edition and going to Standard/Developer/Enterprise
I would like to move from SQL Server 2008 R2 Express to SQL Server 2008 R2 Developer or Enterprise.
I just noticed that I have the following services running:
SQL Server (MSSQLSERVER)
SQL Server ...
3
votes
1answer
474 views
Data Collection reports fail because login is from an untrusted domain
I've set up a data warehouse and Data Collection according to BO. Reports are generated properly when running them in Management Studio running on the server but fail when they are run from Management ...
3
votes
2answers
655 views
Users cannot view tables in non-default schema in SSMS
I'm having an issue setting the VIEW DEFINITION permission appropriately at the schema level for one of my users. I've created the schema TestSchema and added some tables. The user currently has ...
3
votes
0answers
144 views
Login failure error log when querying Central Management Server group
I am querying a group under a Central Management Server, which results in the following being logged to the SQL Server Error Log.
Error: 18456, Severity: 14, State: 38. Login failed for user
...
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 ...
2
votes
3answers
786 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
1answer
623 views
SQL Server 2012 is putting [brackets] around Table and Column Names
Is there anyway to turn that off? I'm unable to find anything in options, and they're really a distraction.
2
votes
1answer
70 views
Attaching a database in SSMS gives error
I am accessing SQL Server using SSMS, and a user with adequate permissions.
When this user tries to attach a database by using SSMS (by right clicking on database node and then clicking on attach), ...
2
votes
3answers
433 views
Can I get SSMS to show me the Actual query costs in the Execution plan pane?
I'm fixing performance issues on a multistatement stored procedure in SQL Server. I want to know which part(s) I should spend time on.
I understand from How do I read Query Cost, and is it always a ...
2
votes
2answers
208 views
Remove Database from SQL Management Studio Database List
I'm working with MS SQL Express 2008 and Visual Studio 2010.
If you are attached to a local MDF file how do you remove it from the Databases list without deleting the file? The reason is to purge the ...
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 ...
2
votes
2answers
120 views
Can you edit the context menu options?
Is there a way (registry hack is acceptable) to remove options from the context menus in SSMS?
Specifically I'd like to remove the delete option from the context menu when you right click on a ...
2
votes
1answer
26 views
Display query which SSMS executes from Interface/WYSIWYG edits
If I am to add a new column to a table in SQL Server Management Studio 2008 via the interface/WYSIWYG (as opposed to writing a SQL query) this will, behind the scenes, create a SQL query which it will ...
2
votes
2answers
84 views
force to forget logins
How can I force SSMS to forget the recently used logins?
Of course I use "SQL Server Authentication" with Login/Password fields.
(It get's annoying, as everytime I open SSMS it shows the "Connect to ...
2
votes
2answers
53 views
How can I get a copy of the SQL generated by Management Studio?
If I save a table in Management Studio's Table Designer for example, I believe it runs DDL SQL in the background. Is it possible for me to grab this SQL so that I can save it to a file?
2
votes
4answers
301 views
SQl Server Password Change after installation
I have installed SQL Server 2005, but at the time of installation I forgot to change my password. Now I can access my database only in window authentication mode, and I want to access the database in ...
2
votes
2answers
3k views
SQL 2008 R2 creates user/schema when Windows user creates tables
We added a server login and database user that map a Windows Group to a SQL 2008 R2 instance using the following script, with the names changed for anonymity:
USE master
go
CREATE LOGIN ...
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 ...
2
votes
2answers
586 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
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 ...
2
votes
1answer
125 views
SSMS login to different domain
Our production database is hosted by another company on their domain. I'm able to RDP into the box and login with the credentials they provided me but when I try to login from my local computer on my ...
2
votes
1answer
78 views
Reset the numbering at the tabs of the Microsoft SQL Server Management Studio
I notice there are some numbering on the tab of each new query (such as the number 52, 56, 57 and 58 as shown in the following pictures)
What does these numbers means and is it possible to reset to ...
2
votes
2answers
332 views
How to assign CTRL+F1 to sp_whoisactive in ssms 2012?
When I go to Tools > Options > Environment > Keyboard.
Type in Query.Sp_whoisactive
Press shortcut keys: Ctrl+F1
Click Assign.
When I press Ctrl+F1, It still calls Help.
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 ...
2
votes
1answer
69 views
SSMS 2012 is not showing the tables of the system databases
I have SQL Server Management Studio 2012 on my laptop connected to a SQL Server 2012. If I go in System Databases and then any of the 4 (master, model, msdb, tempdb) I don't have the Tables folder.
...
2
votes
1answer
33 views
SSMS 2008 Object exploer not showing
Has anyone seen this issue. I am using SSMS 2008 (x64 Version 10.0.5768.0) on Win 2008 R2 machine. Management studio crashed and then when I launch it, it doesn't show Object Explorer even when I ...
2
votes
2answers
294 views
How to map another server through SQL Server Management Studio
I am trying to map another server by giving the command
EXEC xp_cmdshell 'NET USE H:\568.256.8.358\backup_147 1234abc /USER:cranew /PERSISTENT:yes'
I got an error with this network path not ...
2
votes
2answers
138 views
How can I test sql scripts intended to run with sqlcmd -v in Sql Server Management Studio
From msdn I learn, that the Variable Precedence of :Setvar X Y is higher, than that of sqlcmd -v X=Y.
I want to write a script, that uses the variables supplied to sqlcmd with the -v option, but ...
2
votes
1answer
79 views
IntelliSense alternative using SSMS 2012 in a contained database as a contained user?
According to this answer about contained database disadvantages:
If you connect to a contained database as a contained user, SSMS will
not fully support IntelliSense. You'll get basic ...
2
votes
1answer
623 views
Cannot connect remotely to sql server 2012 instance using SSMS
I have installed sql server 2012 Express on a local network machine, then added a new login: "sqlUser" mapped to "database1", and configured the instance to accept the remote access with both Windows ...
2
votes
1answer
73 views
Question about new behavior of current connection combobox in SQL Server 2012
I have a question about the new behavior of the database selection combobox in SQL Server 2012 (Press Ctrl + U to move your focus to it). It seems that, unlike in SQL Server 2008 R2, clicking in the ...
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 ).
2
votes
0answers
58 views
How to safely take an SQL job out of the schedule?
There is a table | jobID | status | startTime | endTime | and a job, that is scheduled to run every X seconds, it will take the first undone job ID, put it in stored proc and run it. Stored proc takes ...
2
votes
0answers
58 views
How to display differential backup date in SSMS Object Explorer Details
SQL Server Management Studio exposes the Object Explorer Details (selectable from the View menu option) and its context menu that allows adding fields to the default display.
Full and Transaction Log ...
2
votes
1answer
115 views
SSMS Object Explorer Details causes deadlock while job is running
I have a problem with one of my SQL Server jobs. I've found that while the job is running, SQL Server Management Studio locks up. It always locks up while I'm looking at tables and sprocs within the ...
1
vote
3answers
141 views
How do I use SSMS to compare Database 1 Table 1 against Database 2 Table 1?
I have two database - Database1 and Database2.
Both database contain a table that have similar structure as follows:
...
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 ...
1
vote
2answers
393 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
3answers
61 views
Proper way to export database to other servers
I am using SSMS (I am a software developer, not a DBA) and in each application release I need to release the database with its tables (some with data some with scheme only).
I tried doing 3 things ...
1
vote
1answer
246 views
SQL Server Database Keeps Semi-Detaching Itself
Forgive me if I am not using all the proper terms but I have databases that will detach themselves from SQL Server. In SQL Server Management Studio the plus sign will be missing next to the database, ...
1
vote
1answer
106 views
Error on creating database in SSMS
I am using SQL Server Management Studio 2008. I am connect to localhost and I want to create a database. When I click on New Database, type the name and click ok, I get the message:
Index was ...
