Tagged Questions
5
votes
4answers
57 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
58 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
70 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) ...
0
votes
3answers
57 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
49 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 ...
5
votes
1answer
147 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 ...
0
votes
1answer
96 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
40 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
51 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
258 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
534 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 = ...
3
votes
1answer
139 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
81 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!!
