ssms

How to delete server entries in SQL Server Management Studio’s “Connect to Server” Screen? [duplicate]

by

Looks like this file is a binary serialized version of the Microsoft.SqlServer.Management.UserSettings.SqlStudio class defined in the Microsoft.SqlServer.Management.UserSettings, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 assembly (located at c:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.SqlServer.Management.UserSettings.dll). With a bit of development skill (Visual Studio or even Powershell) you can deserialize this file into the original class, find the entries you want to remove and … Read more

How to open multiple .sql files in only one ssms instance

by

After spending most of my working day looking for the solution I finally found it. Thanks God, I was almost running out with this issue. Hope it helps somebody else!!!. Update: linked domain expired, so here’s what it said: Considering how integrated Microsoft tools usually are the result is frustrating when you tell Visual Studio … Read more

How to extract MSSQLServer database as .dacpac without VerifyExtraction?

by

I wasn’t able to find a method that works in SSMS (2008 R2 or 2012), either, but Visual Studio (2013) with SSDT seems to work: Within VS, go to SQL Server Object Explorer, connect to the server in question, right click the database in question, Extract Data-tier Application, and then adjust the Extract Settings, one … Read more

SSMS shortcut to navigate between open query windows

by

A challenge you’ll find here is what does “next” really mean? Since you can tear off tabs, split the UI, even move tabs onto different monitors, I think “next” and “previous” lose a little meaning, unless you know what order they were opened in. Anyway, some solutions, with older versions (based on when the question … Read more