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
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 ...
4
votes
1answer
76 views
Is it “legal” to CREATE and DROP #SomeTable more than once?
I've got my code sort of segregated as "coherent blocks" that I can insert into a longer "configuration script" over and over, and one of the patterns I'm using is this:
CREATE TABLE #WidgetSetting
...
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
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), ...
3
votes
2answers
80 views
Error while taking backup using SSMS
I am using SSMS. I have about 5 logins. For a particular login I have all server roles other than sysadmin. It is a sql login (not windows authentication). In user roles it has all permission for ...
1
vote
2answers
107 views
Auto-generate scripts to create tables, indexes, etc
In SSMS, we can right click a database/table/index/... and select the "Script As" option to generate a drop and create script.
Is there a way to automate this script generation and drop the scripts ...
0
votes
1answer
41 views
Manually entering data using Management Studio
How can I enter data through the GUI interface rather than an insert command in SQL Server Management Studio 2012? I can't find it anywhere whereas there used to be an option in the previous versions. ...
1
vote
1answer
59 views
Databases list not showing up?
This morning when I logged into SQL Server Management Studio (v 10.0.16) I clicked on the databases node and saw all by db's (they are hosted remotely) as I have done for the last 3 years. This ...
4
votes
1answer
176 views
Newly discovered SQL Server Express has all databases inaccessible/offline
We have several remotes sites at my company and today one of the employees came to me and said their SQL reporting tool stopped working. Up until this point I did not even know this server or ...
5
votes
4answers
64 views
How do I check if a certain SQL statement is being run?
Using SQL Server Management Studio, how can check or see who is running a certain SQL statement?
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.
...
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 ...
0
votes
1answer
34 views
Generate script for SQL Broker objects
I'm using SQL Server Management Studio to generate scripts for all the objects in an existing database:
but the objects related to SQL Broker (messages, queues and services) are not generated.
...
0
votes
0answers
109 views
How to move folder of SQL Server LocalDB instances from the default location?
I get multiple errors with LocalDB (startup error, can't create DB from SQL Server Management Studio and also multiple issues when trying to restore a backup) and none of the fixes I found are helping ...
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.
9
votes
5answers
5k views
Save Results as CSV *with* headers in SSMS
With SQL Server 2008 R2, when I save the results as a CSV there are no headers. I can work around this by copying and pasting with the "Copy with Headers" , or just grab the headers and paste them in ...
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 ...
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 ...
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
53 views
Adding column from SSMS wizard in SQL Server
Today, I am reading through Pinal Dave's blog about adding column in SQL SERVER....One thing make me surprised that while adding column from SSMS wizard, it goes from following process:
Create a New ...
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 ...
1
vote
1answer
324 views
Find all the queries executed recently on a database
[I am a beginner level T-SQL Programmer]
[..and hopefully I am on the right stack exchange site]
I would like to get a list of all the queries I executed (in the least, those I executed today since ...
0
votes
0answers
39 views
Connecting to an SQL Azure Database from SSMS - IP Restriction
I am trying to connect to a new SQL Azure Database via SQL Server Management Studio. The client box running SSMS is hosted on a production DB so we restrict access on 1433 to just a handful of IPs ...
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
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 ...
4
votes
2answers
241 views
Restore SQL Server database from .sql files
So we had an encrypted database that puked and killed our whole SQL Server setup. Sucks about our data, but we were smart enough to have our data structures / stored procedures / functions in Git
The ...
0
votes
2answers
40 views
SQLQueryTableData-Important
In SQL Server Management Studio, when I run the query
select * from tablename
it shows me the data.
But, that table is not physically present in that database. Is it possible?
5
votes
2answers
209 views
Alternatives for SSMS solutions & projects?
According to the official SQL Server Documentation, the use of "Solutions, Projects, and Items" is deprecated. A conspicuous (though somewhat cryptic) warning banner at the top of the MSDN page ...
5
votes
3answers
650 views
SQL update satement taking a very long time / high disk usage for hours
Yes it sounds like a very generic issue, but I have not been able to narrow it down very much yet.
So I have an UPDATE statement in a sql batch file:
UPDATE A
SET A.X = B.X
FROM A JOIN B ON A.B_ID = ...
4
votes
1answer
161 views
Is “Estimated Number of Rows” always per execution within SSMS execution plans?
When I look at execution plans, I often compare "Estimated Number of Rows" with "Actual Number of Rows", looking for discrepancies. For example, when I hover over the bottom arrow in the picture ...
0
votes
0answers
88 views
SSMS Delay Notification [closed]
Hi All,
I am getting this notification very often on SQL SERVER MANAGEMENT STUDIO.
Did any body got the same notification and any any solution to resolve this.
Thanks for your time!!
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
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
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 ...
0
votes
0answers
111 views
SQL Server 2008 R2 Database Diagram Error Code
I have sysadmin privileges on a SQL Server 2008 R2 server. I'm working with the development database and want to save a database diagram I created. When I try to save I get the following error ...
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
1answer
789 views
How to downgrade my mdf file from version 661 to 655 or earlier?
I have a problem when attaching the file AdverntureWorksLT2008R2_Data.mdf to Microsoft SQL Server Management Studio (SSMS).
The database 'AdventureWorksLT2008R2' cannot be opened because it is ...
0
votes
1answer
123 views
Color syntax printing in SSMS 2012
It seems the SSMS of Sql server 2012 cannot print the SQL statements with syntax color anymore. Is it a bug? Does it have any workaround?
1
vote
1answer
72 views
Upgrading to SSMS with SQL Web Edition turned off Code Outlining : How do I get it back?
I upgraded to SQL Server 2008 R2 Web from Express with Advanced Services recently and code outlining went away. How do I get my collapsible code back?
Thanks
0
votes
0answers
129 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS database instance using the master account I created when creating the ...
7
votes
1answer
1k views
How can I force SQL Server Management Studio to update metadata?
Metadata in SSMS isn't updating unless I shut it down and restart. I've tried disconnecting from the server and reconnecting while the SSMS session is active, but that isn't working.
Steps to ...
4
votes
1answer
454 views
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio
I'm trying to restore one of my Amazon DRS SQL Server databases. Using SQL Server Management Studio, I can correct to my DRS instance using the master account I created when creating the database ...
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, ...
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 ...
4
votes
3answers
443 views
Large set of execution plans hangs up SSMS
I have a stored procedure that takes about 3-5 seconds that I'm trying to understand so I want an execution plan for it. When I run it in SQL Server Management Studio with Execution Plan enabled, it ...
4
votes
2answers
3k views
Can I use SQL Server Management Studio 2012 on a 2008 server?
My school is using SQL Server 2008. Last time I used it I only installed (at home) SQL Server Management Studio 2008 part, and used VPN to connect to school's server.
Now I want to install SQL Server ...
0
votes
2answers
253 views
How do I modify the user interface language in SSMS?
How do I modify the user interface language in SQL Server Management Studio?
For instance, if I installed in English, but wish to view in Japanese (to name but one possible example).
I am running ...
4
votes
1answer
138 views
Besides attaching the debugger, is there any other differences between “(local)\Instance” and “MyLocalName\Instance”?
When using SQL Server Management Studio for SQL Server 2008 R2 connecting to a local SQL Server 2008 R2 instance (version 10.50.2500), I know that if I am using the instance name (local)\sql2008 it ...
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 ...
5
votes
2answers
401 views
SQL Server Management Studio 2012: How to have folders in the SSMS project?
I'm using SSMS 2012 to talk to the SQL server 2012 and Azure SQL servers we use. I admit I'm not a SQL expert so I've been saving most of my SQL scripts for future reference. I've quickly run into 20 ...
