SSMS

How to find unsaved file location for SQL query in management studio

This is important if we not saved files on disk and SQL management studio close. Un save file location C:\Documents and Settings\<user name>\My Documents\SQL Server Management Studio\Backup Files\Windows Vista/7/10 %USERPROFILE%\Documents\SQL Server Management Studio\Backup Files OR %USERPROFILE%\AppData\Local\Temp Sql Query find using statics Query Recovery Settings There is a setting in Management Studio that allows the Autorecover …

How to find unsaved file location for SQL query in management studio Read More »

How to work with Registered Servers in SQL Server Management Studio

In SQL Server management studio their is powerful option to easily connect your server or execute query on that server To open register server window Menu -> view -> register servers Or Ctl + Alt + G We can run same query on all server using this feature Ref Link https://docs.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-2017