Hot answers tagged

26

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?


20

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

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.


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 ...


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 ...


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

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

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

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

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

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

Workaround: Tree/List View IntelliSense behavior is available in the "Object Explorer Details" window. To Start: Click on Object Explorer "Tables" folder. Click F7 and this will bring up the "Object Explorer Details" window. This window allows one to use IntelliSense to find the closest match to what is typed in the Tree/List View. Lastly: Move the "...


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

The GUI is giving you the most recent backup for the database you had highlighted, which I presume is Foo. That dialog is giving you the history of the highlighted database's backups as pulled from MSDB. If you choose "From Device," you can browse to a different backup and use it instead. As to the contents of Foo and their not being an exact copy of ...


2

currently this appears to be a bug in SSMS (present v 2014). I develop SSMSBoost add-in for SSMS and starting from recent release we have fixed that problem. You can use our "Preferred connections" and specify "Additional connection parameters", which will be saved by our add-in correctly. Hope this helps !


2

Have you tried right clicking on the window in Task Manager on the application tab and choosing maximize? That usually works for me.


2

Seems to be a known (unresolved) bug: https://connect.microsoft.com/SQLServer/feedback/details/3009405/ssms-2016-fails-on-windows-10-version-1607-while-trying-to-execute-it-as-a-different-domain-user SSMS 2014 still works fine so that's a workaround, or as @yahmoth555 suggested, use a different build of Windows.


2

It's hard to say for certain, but I would check the following things: SQL Express is limited to databases 10 GB or smaller. Has your database grown to a size larger than that? But based on the error message: Does the SQL Service Account have full access to the directory where the database lives? Does the SQL Service Account have full access to the file?...


2

Your query is returning memory used by SQL, not the max server memory it's allowed to consume. How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL? This will show you how to get that value via query. SELECT name, value, value_in_use, [description] FROM sys.configurations WHERE name like '%server memory%' ORDER BY name ...


2

You can truncate the log file by issuing the following code block from SSMS: -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE AdventureWorks2012 SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (AdventureWorks2012_Log, 1); GO -- Reset the database recovery model. ALTER ...


2

This behaviour is expected. SQL Server runs on the remote server, in a service account so it cannot not see your own volumes. Why would SQL Server have any special rights to see your local computer?. You have to create a file share on your local computer, assign appropriate permissions and then you CAN use UNC format (\computername\sharename) to use that ...


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