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
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 ...
1
vote
1answer
323 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 ...
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 ...
1
vote
4answers
458 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 ...
1
vote
1answer
81 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 ...
1
vote
1answer
87 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 ...
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 ...
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 ...
1
vote
1answer
604 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 ...
1
vote
1answer
938 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 ...
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 ...
1
vote
1answer
208 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 ...
1
vote
1answer
43 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. ...
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
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 ...
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 ...
1
vote
1answer
584 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 ...
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 ...
0
votes
1answer
156 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 ...
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 ...
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
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 ...
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. ...
0
votes
1answer
627 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 ...
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 ...
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 ...
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?
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?
0
votes
2answers
620 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.
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 ...
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 ...
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!!
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 ...
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 ...
0
votes
0answers
175 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 ...
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, ...
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 ...
-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).
