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.
1
vote
1answer
104 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
4answers
2k views
Copy Database option not found in SQL Server Management Studio 2008 R2
I am unable to see the Copy Database option in SQL Server Management Studio 2008 R2.
Can anyone tell me whats going on please?
6
votes
1answer
212 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 ...
3
votes
2answers
67 views
Is there a limit to how many credentials SSMS can remember?
Using SQL Server Management Studio that came with SQL Server 2008 R2, I make connections to the same server using a number of different sets of SQL Server Authentication credentials. On my development ...
3
votes
2answers
76 views
Import Data replaces NULL with 0
I am using sql server 2008 r2 express. I am getting some problems when i use import data feature to import data from one database to another. I am using SSMS to do it. While using the wizard i choose ...
0
votes
0answers
29 views
How to disable SSMS table designer timeout?
How do i disable the Table Designer timeout in SQL Server Management Studio?
Background
This KB Article seems to indicate that if you stop overriding the Designer timeout:
To resolve this ...
7
votes
2answers
4k views
Is SQL Server 2012 Management Studio “Express” any different?
Are there any differences from the version of SSMS that comes as part of the SQL Server 2012 Enterprise Installer and the SQL Server 2012 Express Management Studio?
0
votes
1answer
37 views
Connection to local SQL Server 2012 can be established from SSMS 2008 but not from SSMS 2012
I have two local SQL Server instances running on my local machine. The first is SQL Server 2008 R2 Enterprise Edition (named MSSQLSERVER) and the 2nd is SQL Server 2012 Business Intelligence Edition.
...
3
votes
1answer
95 views
Linked server available to users without permissions
I have users seeing a linked server which they are not supposed to see.
The linked server is defined so that only I will have access to it, but everybody can see and use it.
I have created the ...
14
votes
3answers
890 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 (Impact xxx)" my kneejerk reaction is to just create the new index. This results in a faster ...
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 ...
2
votes
0answers
73 views
Why does GO affect my SELECT? [closed]
I am experiencing a very weird behaviour from the Management Studio GO.
I am following the full-Text Search tutorial and I run the following query over adventure works
SELECT ...
3
votes
2answers
747 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
80 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
27 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
87 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
96 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
175 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
55 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. ...
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
85 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
64 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
44 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
142 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
343 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
134 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
92 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
44 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
54 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
61 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
518 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
41 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
142 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
34 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
263 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
220 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
898 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
185 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
103 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!!
3
votes
2answers
4k 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
674 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
822 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
118 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
170 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
1k 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
139 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
74 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
141 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 ...
