Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [ssms]

SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.

192 questions
1
vote
1 answer

Shut down operating system by killing task

I came across quite an odd error recently and was wondering if anyone has any insight into it. I can't find any reference to such a scenario on Google so here goes... The rough sequence of events is like this: RDP into a Windows 2008 R2 and start…
Jon.Mozley
  • 173
  • 1
  • 7
1
vote
1 answer

Why does SSMS Restore Database to another database not copy the current state of the "From" database?

When copying a database by using the Restore Database functionality in SSMS, why is it not a copy of the current state of the Database? After performing the Restore From Database Bar to Database Foo, the data contained in Foo is about a month older…
Joel Peltonen
  • 169
  • 1
  • 2
  • 9
1
vote
1 answer

"SQL Server 2008 Management Studio failed to load" after upgrading to Windows 7

I upgraded from Vista to Windows 7 and since then the SQL Server 2008 SP1 Management Studio Package is broken. Whenever I start it, it just shows the message "Package 'Microsoft SQL Management Studio Package' failed to load". and closes again…
Adrian Grigore
  • 1,072
  • 3
  • 21
  • 34
1
vote
1 answer

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this means? Does it means that the 1)users cannot log…
Laughy
  • 111
  • 1
1
vote
1 answer

In SSMS, editing a table, can column names be sorted alphabetically?

SSMS Sorts column names alphabetically in all its dialogs - when choosing columns for indexes, relationships, etc. However, when editing ("Designing") a table, the columns are listed in the order in which they were added to the table, which seems…
ingredient_15939
  • 141
  • 1
  • 2
1
vote
1 answer

What happens if a stored procedure is run in SSMS and it crashes?

What happens if a stored procedure is run in sql server management studio (SSMS 2012 to 2005 server) and it crashes? I'm guessing the stored procedure continues to run? On the other hand I have read somewhere that if a connection is lost and a…
Alex KeySmith
  • 721
  • 2
  • 10
  • 19
1
vote
4 answers

Add conditions to maintenance plan sequence on SQL Server

I would like to add a condition to a sequence in my SQL Server 2008 Maintenance Plan. This condition is based on the variable set by a T-SQL Statement Task: declare @primary bit = 0 select @primary=1 from sys.database_mirroring where mirroring_role…
Idriss
  • 125
  • 1
  • 7
1
vote
0 answers

SQL Server 2005 on Windows 7 along with SQL Server 2008 R2 Express Edition

I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications. I have a license for SQL Server 2005 (32 bit) and when I tried to…
µMax
  • 111
  • 2
1
vote
0 answers

What does this setting do when copying SSIS packages? "Duplicate package folder structure on destination for selected packages"

What does this setting do for copying SSIS packages? "Duplicate package folder structure on destination for selected packages." Is there any reason why I wouldn't want to duplicate the folder structure?
Ian R. O'Brien
  • 111
  • 6
1
vote
1 answer

Why does SQL Server Management Studio sometimes lose my authentication information?

When I launch SQL Server Management Studio, most of the time it remembers the login & password, but from time to time, I have to retype the password. Is this something that happens periodically for security, or is it a bug, or is it something that…
Matthew Farwell
  • 113
  • 2
  • 7
1
vote
1 answer

Why does SQL Server Management Studio fail to connect on the first attempt?

When accessing SQL server on a remote development PC via Management Studio the connection will consistently fail on the first attempt. After the failure I retry and can now successfully connect to the database. This isn't a huge issue, but when I…
awilson53
  • 125
  • 1
  • 7
1
vote
1 answer

Remote connection to SQL Server 2008 in LAN

I try many ways, but still doesn't work. MSSQLSERVER is running. SQL Agent is running. SQL Browser is running. TCP/IP is enabled (something else inside it must I change?) Named Pipes is enabled Allow remote connections to this server - checked. I…
Saint
  • 111
  • 2
1
vote
3 answers

Option do not show schema names in SQL Server Management Studio

I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you. This works in SSMS, but there's an annoying problem, especially…
Jörgen Sigvardsson
  • 115
  • 1
  • 6
1
vote
1 answer

Removed SQLServerAgent account What should I do ?

I have removed by accident SQLServerAgent account and now I cant get access to the database. Connecting from management studio throws me error 26 and system log shows: SQLServerAgent could not be started (reason: Error creating a new session). . I…
xp11
  • 13
  • 3
1
vote
2 answers

SQL Server 2008 Express: How do you remove a Database Engine instance?

I tried upgrading SQL Server Express 2008 to SP1, but the Setup was very far from clear. I ended up with 2 database engines. I now want to install Management Studio Express, but it apparently means I have to create yet another database engine. How…
Aximili
  • 113
  • 1
  • 1
  • 6
1 2 3
…
12 13