Questions tagged [ssms]
SQL Server Management Studio is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.
192
questions
22
votes
4
answers
41k
views
SSMS: Where does SQL Server store its server names?
I have a number of "old" servers or server names with a typo in them that keep showing up in my dropdown list of server in the "Connect to Database" dialog of SQL Server Management Studio:
Where are ...
- 1,152
17
votes
4
answers
35k
views
Timeout saving table in SQL Server
I'm trying to add a column to a table with much data in SQL Server 2005, using SSMS.
So I browse to the table, select Modify, and add the new column. Then, when I press Save, I get the following ...
- 449
13
votes
8
answers
62k
views
Activity monitor is unable to execute queries against server
Is there any fix to get SSMS activity monitor working?
Problem:
SQL Server Activity Monitor fails with an error dialog:
TITLE: Microsoft SQL Server Management
Studio The Activity Monitor is
...
- 1,466
13
votes
3
answers
7k
views
Can't see second azure sql database in SSMS object explorer
I have created a second database on my existing Azure SQL server. The first database works fine and I can see it using SSMS.
I cannot see the second database in the object explorer. Autocomplete ...
- 263
13
votes
10
answers
88k
views
Can't remotely connect through SQL Server Management Studio
I have setup a SQL Server 2008 Express instance on a dedicated Windows 2008 Server hosted by 1and1.com. I cannot connect remotely to the server through management studio. I have taken the following ...
- 279
12
votes
5
answers
36k
views
How do I restore a batch of transaction logs rather than one by one
I have a SQL Server database that backs up the transaction logs every 10 minutes, with an overnight full backup.
Using SQL 2008 Management studio we seem to have to select each transaction log one ...
- 555
11
votes
6
answers
20k
views
How can I have SQL Server Management Studio 2008 connect to my instances automatically?
I'm running a server with 3 database instances.
Right now, when I open Management Studio, it opens the "Connect" prompt that lets me choose which instance I want (or connect to anything else).
Would ...
- 1,432
10
votes
4
answers
12k
views
Sql Server Management Studio 2008 has suddenly become unresponsive
I'm getting a very strange error when I try to launch SSMS from my taskbar. It seems to open in normal speed, but responds to any input with just a beep. CPU usage is 0% in Task Manager, and there is ...
- 619
8
votes
3
answers
16k
views
Can't run SSMS as another user - requires elevated permissions
On Windows 10 and SSMS 2016, I can no longer start SSMS as another user. I need to be able to do this in order to use trusted authentication to connect to some of my databases. This used to work fine, ...
- 241
8
votes
3
answers
3k
views
SQL Server Management Studio - "Restore from Device" dialog is slow
Whenever I try to restore a database in SQL Server the dialogs take an excessively long time to open. The worst offender seems to be the "Select backup devices" modal sub-dialog from the Restore ...
- 264
7
votes
1
answer
3k
views
SQL Server Debugging: "Unable to Step. Invalid operation"
I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up:
Microsoft SQL Server Management Studio:
Unable to Step. Invalid ...
- 730
6
votes
2
answers
6k
views
Why is SQL Server 2005 hanging up when I try to delete a database?
I've got a Windows 2003 server with SQL Server 2005 and when I log into the Management Studio, right-click on a Database and choose "Delete" I get the Delete Object dialogue. I then click OK at the ...
- 205
6
votes
5
answers
14k
views
How do you configure a MS SQL Server to prevent exposing all database names and logins to any authenticated user?
I'm new to MS SQL and asking this question as a web developer with limited sysadmin experience who desires his service providers to use best practices.
We have one database on a remote MS SQL server ...
- 163
6
votes
2
answers
600
views
SQL Server Management Studio Connect to Server List Editing
I'm using SQLServer Management Studio (2005) and I have a fairly lengthy list of servers in there, and I'd like to get rid of some of them that are no longer in use, without having to set them all up ...
- 231
5
votes
2
answers
7k
views
Using SQL Server 2008 Management studio to connect to SQL Server 2005 databases
I have a shared hosted SQL Server 2005 at an ISP, that I can connect to from SQL Server 2005 Management Studio. However, I cannot connect from SQL Server 2008 Management Studio.
I log on with SQL ...
- 1,049
5
votes
1
answer
6k
views
Is there a way of setting up a shortcut to a database for MS SQL Server Management Studio
I'd like to have a list of my database servers (I am a developer), I currently have a list of RDP files for different machines I connect to. Is there a similar feature in SQL Server Management Studio ...
- 665
5
votes
1
answer
92
views
Back up a database nightly
Question: Is it possible to automate the process of coping a full database every night into the development database on the same server?
Software: Windows Server, SQL, SQL Server Management Studio, ...
- 151
4
votes
8
answers
16k
views
SQLServer - need to access an ACT! database for data migration
I'm looking for a way to access data in an ACT! database for a data migration to a custom application.
The ACT! software uses SQLServer 2005.
The data conversion script and new application will be ...
- 41
4
votes
2
answers
285
views
Installing .NET 1.1 over later versions: Safe?
I have a server that is running all versions of .NET Framework, from 2.0 up to 4.0. An application I need to deploy won't run correctly on later versions, and was originally compiled for 1.1. Is it ...
- 337
4
votes
3
answers
16k
views
Hide database from other users in SQL Server 2008
I have created a database in SQL Server 2008 and it shows in server object explorer to all users that can login to SQL.
I want to hide it from those users, I want it to be viewable by me only.
How ...
John
4
votes
2
answers
12k
views
export proper csv from SqlServer management studio query result
in SqlServer management studio, you can export query results to a csv file by right click -> "Save Results as" -> csv. However, the csv file does not contain column headers and does not escape any ...
- 153
4
votes
5
answers
20k
views
Results copied from SSMS splitting across columns when pasted into Excel
SSMS 2008 -> Excel 2003
This isn't happening all the time, but sometimes when I 'copy with headers' from sql server management studio, the results in Excel look as though I've used the 'text to ...
- 171
4
votes
2
answers
4k
views
Weird bug when copying from sql server management studio to excel in windows 7 [closed]
I run a query in SQL management studio (results to grid), then select all results and copy with headers. Then I paste into Excel.
The result: two specific records are put together on one row in Excel....
- 41
3
votes
3
answers
13k
views
SQL Server 2005: Copy SQL Server Agent Job?
I have a SQL Server Agent job comprised of 10 steps and each step has many parameters defined. Now I need another job almost exactly the same, but with a few differences. Since "copy / paste" isn't an ...
- 3,444
3
votes
3
answers
13k
views
Can I change a live SQL Database from Autogrow safely?
I have a live SQL 2005 database, and am in the very unfortunate position of being the involuntary DBA.
The database has an MDF file that is 1.4 GB, and an LDF with 2.2 GB. The Autogrowth is set to ...
- 555
3
votes
1
answer
20k
views
Cannot connect to SQL Server Integration Services from SQL Server Management Studio: "Class Not Registered"
On a server running Windows Server 2012 R2 Datacenter, I have installed MS SQL Server 2014, using a very typical installation. On a Windows 7 client, I have installed SQL Server Management Studio 2016....
- 173
3
votes
1
answer
419
views
Why does SQL Server Management Studio generate two renames in a change script?
I have just created a change script using SSMS 2008 Express, for renaming two columns in a table. However, the change script contains four renames, using an intermediate temp name. Why is this?
...
- 493
3
votes
2
answers
3k
views
How to install Microsoft SQL Server 2008 Management Studio Express
I have Microsoft SQL Server 2008 Express Edition already installed, and now I want to install SQL Server 2008 Management Studio Express.
I've tried with the only two options that look feasible:
[...]...
Jose Carlos
3
votes
1
answer
3k
views
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' on Azure SQL with Active Directory Admin via SSMS
When I attempt to connect to an Azure SQL Server via SQL Server Management Studio using the "Active Directory - Universal with MFA support" method with an account that is configured as the Active ...
- 181
3
votes
1
answer
1k
views
Is SQL Management Studio 2012 avaliable, without Engine itself?
On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened.
Is it possible to get SQL Management Studio 2012 ...
- 541
3
votes
2
answers
2k
views
SQL Management Studio - Restore from device problem
When specifying the Backup location by trying to click the Add button the dialog hangs and does not recover. This happens on all of our SQL 2000/2005/2008 environments. Could it be due to them running ...
andrew
3
votes
1
answer
2k
views
What permissions does SSMS Intellisense rely on?
We have a server on which SQL Server 2008 is running. When we connect to it with SSMS with some logins (from SSMS 2008), Intellisense is available. For others it isn't. The logins in question connect ...
- 1,305
3
votes
1
answer
15k
views
unable to connect to sql server analysis services on windows vista
I just installed sql server 2008 developer edition on my windows vista machine. The installation was successful. Reporting service is working fine. But I am not getting any option to connect to "...
- 133
3
votes
1
answer
384
views
Access Denied issue, SQL Server LocalDB on Windows Server 2008 R2 SP1
Running SQL Server LocalDB 2012 and 2014 on Windows Server 2008 R2 SP1 VM I have some bizarre issues which don't happen when running on Windows 7 or Windows 10.
I can create databases, save data to ...
- 173
3
votes
1
answer
7k
views
How do I permanently add additional connection parameters in SQL Server Management Studio
In the "Additional Connection Parameters" tab of the login form for SQL Server Management Studio (most recent versions), one may specify custom connection string parameters. See http://technet....
- 153
3
votes
2
answers
2k
views
How to connect to SQL Server via SQL Server Management Studio 2008?
I can't seem to get this to work. I have an IP address for a SQL Server. I have a login and password.
How can I connect to it and work with it?
eski
3
votes
2
answers
2k
views
SQL Server Management Studio not scripting all objects
i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some.
i can provide detailed screen shots
the ...
- 5,313
3
votes
0
answers
3k
views
Restoring database from SSMS UI freezes SSMS
I am using SSMS 17.3. I try to restore a database from the UI, click on 'Device' radio button and click on the ... to select a file, SSMS freezes. I have to kill it. I have to restore databases using ...
- 954
3
votes
1
answer
1k
views
Viewing history for Maintenance Plan causing out of memory exception
I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
- 31
2
votes
5
answers
5k
views
SQL Server 2008 (SSMS) : Find next run date for a job
I would like to know if there is a way to get the next time a job is supposed to be running in SQL Server 2008, using a T-SQL query or even in SSMS if possible, without having to consult all the ...
- 237
2
votes
3
answers
2k
views
How can you schedule a database backup on SQL Server 2005?
Not really familiar with MS SQL Server, but I did figure out how to manually backup a database locally:
In SQL Server 2005 ( SP2 ) using MS SQL Server Management Studio :
I navigate to
Server->...
- 45
2
votes
3
answers
2k
views
sql server management console doesn't work with multi-byte characters
I'm trying to work out how to use SQL server management studio properly with multi-byte unicode characters. even something as simple as:
select N'动漫'
just returns square boxes in the result pane. I ...
- 499
2
votes
3
answers
181
views
Is it destructive to use SQL Server Management Studio to modify properties on an MSSQL 2000 database?
We have a few databases that are stuck in legacy mode at SQL Server 2000. I commonly use SQL Server Management Studio from SQL Server 2005 to query the data in these dbs from my desktop, but have ...
- 381
2
votes
1
answer
180
views
Why can't I restore encrypted backup through front end?
I'm just starting to experiment with encrypting backups, I think I now understand it and have got the process working, but something strange is happening with restoring.
On Server A (SQL 2014 ...
- 1,583
2
votes
4
answers
2k
views
Sql Management Studio 2014 wont connect to clustered instance
I am experiencing an issue where my instance of SQL Server Management Studio 2014 will not connect to any of our production clustered SQL 2000 and 2005 instances. It will however connect to non-...
- 71
2
votes
2
answers
166
views
SSMS import large table
I'm trying to move several tables of data between 2 MSSQL 2008 databases, I have generated data insert scripts for one table which is quite large (around 3.5M rows) The script is around 3GB. When I ...
- 127
2
votes
4
answers
2k
views
Is allowing remote Sql Server Management Studio safe?
I administer a website that runs on IIS on one box, and SQL Server 2008 Workgroup on another box. typically I remote into the DB box and run SSMS to work on the db, but I would like to be able to ...
- 123
2
votes
2
answers
5k
views
SQL Server Managment Studio 2016 fails to open; multiple errors
Installing this was nothing short of a headache. I had countless issues. In order to install this (16.5.1), I had to uninstall C++ redistributable 14.0.24210, and install version 14.0.23026 in order ...
- 21
2
votes
2
answers
1k
views
Any known SQL Server 2008 Management Studio memory leak issues?
I'm not sure whether this question belongs here or to StackOverflow. I'm attempting here, since my question is in regards of memory leaks and management stuff more than programming.
I have a SQL ...
- 256
2
votes
2
answers
800
views
Backup MS SQL 2000 db from SQL Management Studio 2005 on another server?
The situation: I have an instance of MS SQL 2000 running on one server. On another server I've installed SQL Management Studio Express 2005. I can access the SQL 2000 server from Management Studio. I ...
- 687