Tagged Questions
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
75 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 ...
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
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), ...
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 ...
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)
1
vote
1answer
514 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 ...
5
votes
3answers
891 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 = ...
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 ...
4
votes
1answer
152 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 ...
2
votes
2answers
86 views
force to forget logins
How can I force SSMS to forget the recently used logins?
Of course I use "SQL Server Authentication" with Login/Password fields.
(It get's annoying, as everytime I open SSMS it shows the "Connect to ...
4
votes
3answers
477 views
Large set of execution plans hangs up SSMS
I have a stored procedure that takes about 3-5 seconds that I'm trying to understand so I want an execution plan for it. When I run it in SQL Server Management Studio with Execution Plan enabled, it ...
7
votes
1answer
112 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
95 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 ...
0
votes
0answers
197 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 ...
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
2
votes
1answer
144 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
118 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 ...
3
votes
0answers
150 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
...
3
votes
1answer
491 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
593 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
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?
1
vote
1answer
336 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
251 views
SQL Server Database Keeps Semi-Detaching Itself
Forgive me if I am not using all the proper terms but I have databases that will detach themselves from SQL Server. In SQL Server Management Studio the plus sign will be missing next to the database, ...
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 ...
1
vote
1answer
617 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 ...
5
votes
3answers
275 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 ...
5
votes
2answers
134 views
Is is possible to manage SQL Server 2008 databases via R2 Management Studio?
Is it possible to manage SQL Server 2008 databases using SQL Server 2008 R2 Management Studio?
