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.
7
votes
1answer
108 views
Error in SSMS when attempting to restore a database
We have over a dozen SQL servers, one of which hosts a couple of hundred sage databases, when i right-click on the Databases node in SSMS there is a long delay then i get the following error (and the ...
1
vote
2answers
94 views
How to connect to SQL Server Analysis Server via Management Studio command line
I can connect SQL Server Management Studio to a SQL DB by passing command line parameters like this:
"C:\Program Files (x86)\....\Ssms.exe" -E -S SERVERNAME -d DB_NAME -nosplash
(Obviously -E is ...
2
votes
2answers
277 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
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 ...
0
votes
0answers
173 views
Cannot change the Delete Rule of a self referencing foreign-key-relationship to cascade delete
I have the following table
[dbo].[myObj](
[ID] [int] IDENTITY(1,1) NOT NULL,
[fk_ParentID] [int] NULL
)
and I have a relationship from fk_ParentID to ID.
I want to change the Delete Rule in ...
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?
1
vote
1answer
205 views
To run SQL Server Profiler or to use the SQL Server Agent's Jobs function in SSMS or …?
I have a problem here - I wish to keep track of all transaction executed on the SQL Server but was wondering how should I proceed.
If I were to use the SQL Server Profiler and configure it to store ...
5
votes
1answer
89 views
Can We Perform an “Up-To-The-Minute Restore” After Taking Transaction Log Backups?
The Setup:
Say we have a Database in Full Recovery Mode that does a nightly Database Backup, Transaction Log Backup, and Transaction Log Shrink.
Now the Transaction Log grows so quickly during the ...
7
votes
2answers
1k views
SSMS Tools Pack Alternative
Are there any tools out there comparable to SSMS Tools Pack 2012? The licensing ($30 per machine, $100 for any number of machines... for 3 months) leaves a lot to be desired and I wasn't sure of what ...
1
vote
4answers
426 views
Could not find the Server Agent in SSMS
I am following the guide - http://sqlserverpedia.com/blog/sql-server-bloggers/how-to-create-a-server-side-trace-with-sql-profiler/ which is working until I reach Step 8
8. Now to schedule your newly ...
4
votes
2answers
833 views
Allowing Foreign Key to be Null
I'm trying to create a relationship between two tables where one column in TABLE A is the foreign key for a column in TABLE B. However, there is one row in TABLE B that is currently null in that ...
2
votes
3answers
417 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 ...
1
vote
1answer
42 views
Trying to take a backup of a database, but drives are different than in file explorer
In SQL Server Management Studio for SQL Server 2008, I do the following:
In the Object Explorer windows, right click on the database
Choose Tasks -> Back Up...
The Back Up Database windows appears. ...
0
votes
1answer
607 views
Could not start the SQL Server Agent (SQLEXPRESS) [duplicate]
Possible Duplicate:
Sql Server agent can not start
I could not start the SQL Server Agent (SQLEXPRESS) instance as it will give me this error:
The request failed or the service did not ...
1
vote
2answers
7k views
Error: Specified cast is not valid. (SqlManagerUI)
I am trying to restore database created on server to my localbox however i am getting 'Error: Specified cast is not valid. (SqlManagerUI)' error message.
Server Info:
Windows Server 2008 Standard ...
3
votes
1answer
246 views
Executing TSQL script generated from SSMS in SQLCMD. Failing on quotes
I am attempting to deploy a database to a machine by executing a script generated by the "Generate Scripts" tool in SQL Server Management Studio.
Here is the command I've issued:
sqlcmd -S ...
0
votes
2answers
600 views
How to connect once for all queries in SQL Server Management Studio?
SSMS asks me to connect for every query in my project. I know I can let it save the password, but I'm asking if there's another way - so I'll have to type in the password only once per session.
2
votes
1answer
124 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
72 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
2answers
201 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 ...
4
votes
2answers
2k views
"Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio
I have created a table testtable inside the database testbase that have the following structure:
product_no (int, not null)
product_name (varchar(30), not null)
price (money, null)
expire_date (date, ...
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 ...
1
vote
1answer
598 views
Simple Car Rental database
I am trying to learn SQL development using SQL Server 2008 R2 Database Management Studio. I was trying to model a car rental company, where clients can rent cars, and I have to know which client has ...
3
votes
2answers
428 views
Copying View in Management Studio
I want to copy a VIEW from one server to another. I could copy tables but I can't copy views. Is there a way to do so?
Thanks
6
votes
7answers
2k views
Sql Server Management Studio slow opening new windows
After upgrading both sql server and management studio from 2008 to 2012, the management studio 2012 is very slow when new query windows and dialog boxes are opened. Even right click on tables is slow. ...
2
votes
1answer
114 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 ...
5
votes
2answers
185 views
SQLAgentReaderRole and SQL AD ID login case affecting ability to edit jobs
I have AD ID users on a SQL 2008 server that can't edit their own jobs. They can create them, but in order to edit them, they have to delete them and then re-add them. The issue is explained here: ...
0
votes
0answers
119 views
Connect only once for all queries in SSMS?
I have an MSSQL database on a remote server. SSMS 2012 asks me to connect every time I double click a query in "Solution Explorer" in my project despite all of them having the same connection. Also, ...
1
vote
1answer
80 views
How to make SSMS Properties Window coincide with object selected in Object Explorer
The Properties Window in SSMS seems lame to me. All it shows is the current connection properties. I would like to be able to click on an object in the Object Explorer (e.g. a table or a column) and ...
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
...
5
votes
2answers
2k views
Can I connect to a SQL Server 2000 instance from SQL Server Management Studio 2012?
I would like to update my development machine to SQL Server 2012 but I still manage some (very old) SQL Server 2000 machines. Wil my 2012 SSMS be able to connect to those SQL Server 2000 machines?
...
0
votes
1answer
151 views
Database is too large due to appended backup
My database MDF file is at around 600mb. LDF file is at 147MB.
I seriously doubt that it should be anywhere near this.
I suspect it's because the database has been backed up by my host with the ...
2
votes
4answers
294 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 ...
8
votes
1answer
243 views
Why is “Lookup” colored as a function reserved word in SQL Server?
In SSMS 2208, the identifier "Lookup" is colored hot pink as if it were a function (same color as, say, "Power" or "Convert"). Why?
I cannot find it in the official list of reserved words. Searches ...
3
votes
1answer
361 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 ...
9
votes
3answers
271 views
How to control the order of servers listed in the SSMS connection dialog?
My current project involves a lot of database shuffling as we upgrade from SQL 2008 -> 2012, re-task hardware, repeat.
One minor annoyance is the connection dialog in SSMS re-shuffling the server ...
3
votes
1answer
472 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
1answer
539 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 ...
4
votes
3answers
1k views
SQL Server Management Studio Express 2012 “ONLY”
I have installed SQL Server Express(SSMS) 2012 with management tools. After a few months, the Management studio has stopped working. The error is:
««
Evaluation period has expired. For more on how ...
3
votes
1answer
208 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?
4
votes
1answer
2k views
Suppress SQL Server Management Studio auto complete
Is there a way to temporarily suppress SQL Server Management Studio's auto-complete while typing a query? I don't want to disable auto-complete completely just say hold down some key while typing in a ...
3
votes
3answers
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?
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 ...
5
votes
3answers
260 views
Save Connections in SSMS?
Can I save some sort of session or profile in SSMS (2008 r2) that will open up connections to a saved list of database servers when I open SSMS?
So for example I frequently will open up SSMS and ...
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 ...
8
votes
2answers
598 views
Why can't I use NEWSEQUENTIALID() as the default value for my column?
I'm trying to create a table in Management Studio and after reading about the new (from SQL 2005 on) NEWSEQUENTIALID() function, thought I'd give it a go.
This is what I'm doing:
But it's not ...
0
votes
1answer
52 views
Second instance of query designer for a single table in SSMS (Express)?
Forgive me if this is the wrong exchange site for this question. It seems like the right one.
I have been a fan of writing queries manually for a long time, but recently I've got into the habit of ...
2
votes
2answers
118 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 ...
5
votes
2answers
102 views
Does Restore “From database” restore from the most recent backup of the database or the actual live database?
In SSMS 2005, I want to use the GUI to copy a database by restoring in to a new database. I was using the "From database" radio button for the source, but then the databases in the list disappeared ...
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 ...
