Hot answers tagged

25

This might be a very simplistic answer, but this happened to me because a dialog it was attempting to present was off of the desktop and/or hidden behind something else. When it beeps like that, can you do the whole "Alt-Space m" and move something into focus?


13

So for me, it turned out that when I was connecting using SSMS, I had set the database to connect to as my first database by accident - meaning that was all I could see. On connect, go to Options, then check the database you're connecting to. If you're using multiple users to connect to that server like I was, my admin user ended up also being forced to ...


8

In case it helps anyone, I got it working by: Open the location to the shortcut, such as: C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server Tools 17 Right-click > Properties > Compatibility > Select "Run this program as an administrator" Select the button "Change settings for all users" (THIS IS IMPORTANT) Again, select "Run this ...


7

The 'Connect to Server' window is off-screen. If you use Alt+F4, it will close the dialogue but keep Management Studio open. After this you can initiate a new dialogue through the menu and connect to the desired server. After closing, the 'Connect to Server' window should appear inside of the main window the next time you start the program.


6

Back up a database nightly I have a development database that I would like to refresh with the data from the Production database. I would like for this to happen every evening if possible. This way the development site will only be one day behind and any changes made to the data will be overwritten every evening Below are the outlined steps ...


6

Did you try downloading and using SSMS 2014 to see if you can connect? This problem used to come up when using different versions of SSIS and SSMS.


5

I got it installed the other night and it was under Start > Programs > Microsoft SQL Server 2012 (I think was the full name). Same folder structure as SQL Server 2008 R2. You can also just go to Start > Run, and type in ssms.exe. If neither of these work you might want to just search your system drive for the exe to see if it actually got installed. You ...


5

When upgrading from one version of SQL Server Management Studio to another, e.g. 2014 to 2016, you can copy the SqlStudio.bin file from one directory to another and all of your connections will migrate to the new version. Shut down all instances of SSMS. Rename SqlStudio.bin to SqlStudio.bin.saved in "C:\Users\<username>\AppData\Roaming\Microsoft\SQL ...


5

I tried adding additional info to the answer by sphilp but that edit got rejected because some people seem to think it's incorrect. I can assure you: it is not. What I wanted to add: The Registered Servers functionality in SSMS can be used to connect to several servers in just a couple of clicks. If you group the servers together by creating a New Server ...


5

Yes you can use the following command: ssms.exe -S SERVERNAME -d DATABASENAME -E You can either run this using run, or put it into a .txt file and change the extension to .bat and run that. Some more information can be found by runing smss.exe /?: Usage: ssms.exe [-S server_name[\instance_name]] [-d database] [-U user] [-P password] [-E] [file_name[, ...


4

or you can use the actreader.exe utillity that is included in the premium versions of act, to create a read only user for the act! database (I would advise against writing into act!s' databases anyway...) simply start it, enter a password, and then connect using the username ACTREADER and the password you have chosen. done.


4

You need to connect to .\SQLEXPRESS or (local)\SQLEXPRESS


4

Do i need to specify a port in this setting? Yes there needs to be a port number listed there. The port that is listed is the port that was assigned on startup. Every time the machine restarts this port number will change. If so, does it require a firewall exception or is there a better way to circumvent this issue? Setup the Windows firewall to allow ...


3

Yes, it's possible. Installing SSMS 2012 isn't really an upgrade, it's a separate installation of a newer version, so you basically have SSMS 2008 R2 and SSMS 2012 installed side by side. Besides SSMS 2012 Express, you can also install SQL Server Data Tools which is a free "integrated environment for database developers to carry out all their database ...


3

I've experienced this on occasions when a table had a mixture of ntext and nvarchar(MAX) datatypes. Changing all the ntexts to nvarchar(MAX)s fixes the problem.


3

I had the same problem. After some research I found this page which suggests that this is caused by a race condition. Although the workaround given there wasn't applicable for me, after stopping every other debugging processes (Visual Studio) these annoying error messages didn't display anymore.


3

If connection is lost, your session will be closed and all transactions will be rolled back. If you want to run your procedure without interruption, you could execute it as a job.


3

smss.exe is an essential system process in Windows (it is the Windows session manager), and it is not related in any way to SQL studio. If you kill it (and same goes for other system processes, like winlogon.exe or the event logging service), the system might trigger a reboot (last time I've seen that on XP, it was with the countdown window generated by the ...


3

Windows Firewall is blocking sql server 2005 clustered instance connection. It needs UDP 1434 to be open. The down voted reply put me on the right path. Mariano C. MS Support


3

@Randolph West suggested this and it works for me. Basically, when you want to restore database, don't click on the database itself. Instead, click on the folder 'Databases' and then restore.


3

In my case, the reason seems to have been that the user is associated with multiple Azure ADs. I had to specify the Azure AD of the Azure SQL Server using the "Options >>" button:


3

I'd suggest you try tearing down your setup and starting over. You should be able to restore from the SSMS GUI, so long as your certificates are all in place. Without having your setup scripts, it's hard to troubleshoot what might have gone wrong. First, on Server A, you'll want to create a master key: USE master GO CREATE MASTER KEY ENCRYPTION BY PASSWORD ...


2

I used the "Script Job as" and selected "Create To" and "New Query Editor Window". Once it was in the query editor window, I changed the name of the job and ran the code. It created an exact copy of the initial job on the same server. Success!


2

I had this error message whenever I opened a Maintenance Plan. Was running: Windows Server 2008 SP2 SQL Server 2008 R2 10.50.1617.0 SQL Server Management Studio 10.50.1617.0 I downloaded and installed SQL Server Management Studio SP1 (SQLManagementStudio_xxx_ENU) - didn't even upgrade the server itself, and was able to open up Managment Plans after that. ...


2

To remove all entries for new SQL 2014, you need to delete file: C:\Users\(USER)\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin


2

This problem can be caused by Excel "Text to column" feature. What it does is, it breaks a single column into multiple columns depending on which delimiter you choose. Once you use this feature, Excel somehow thinks it is still on and may affect your next copy and past operation. To fix Go to Data > Text To column and select a different delimiter (other ...


2

If you use the SSMSBoost plugin, then you can set any of your preferred connections to "Connect object explorer at startup". This option can be found on the SSMSBoost->Settings->Preferred Connections->List page of the connection. Since I like having the master databases of all the instances I routinely work with at the top of my preferred list, I just ...


2

As far as I am aware there is no way to customise this. If you have two objects named the same but in different schemas e.g. sales.person, hr.person then there would be no way to distinguish them. I read yesterday about http://www.sqltreeo.com/wp/ which allows you to customise the tree hierarchy in SSMS. You may want to look in to that tool but I doubt it ...


2

Your first big problem is that you're trying to load 3GB of data as a script into SSMS. I'm not sure how clever SSMS is but I bet it's trying to load the whole file into memory which will cause it to blow up because it's a 32 bit app - 32 bit apps have a max address space of 4GB of which 2GB is available to the process. You'd be better off using the bulk ...


2

In the registered servers window open "Database Engine" and right click on Local Server Groups. Select Tasks, then "Previously Registered Servers". This should import them.


Only top voted, non community-wiki answers of a minimum length are eligible