Tagged Questions
5
votes
4answers
62 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
65 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.
...
3
votes
2answers
71 views
Error while taking backup using SSMS
I am accessing my sql server 2008 r2 express server 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) ...
1
vote
3answers
59 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
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
162 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 ...
1
vote
1answer
104 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 ...
3
votes
1answer
41 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
52 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
288 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
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
3answers
585 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
152 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
84 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!!
1
vote
3answers
134 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:
...
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 ...
3
votes
1answer
447 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 ...
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 ...
4
votes
1answer
134 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 ...
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 ...
0
votes
2answers
233 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 ...
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
273 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
171 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?
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 ...
4
votes
2answers
831 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 ...
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
418 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
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
2
votes
3answers
415 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
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 ...
2
votes
2answers
135 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 ...
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
2
votes
4answers
287 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 ...
3
votes
1answer
360 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
471 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
535 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 ...
2
votes
2answers
199 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 ...
3
votes
1answer
205 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?
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
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 ...
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 ...
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 ...
