Hot answers tagged

6

I would say don't ever use the "Take Offline" thing in the GUI unless you know for a fact that the database is not in use. By anything. That's hard to know without doing some legwork, so why not save this script somewhere and always use this? USE [master]; GO ALTER DATABASE $dbname$ SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO ALTER DATABASE $dbname$ SET ...


4

This is not possible: the display settings can not be specified per column. If you set the font to one which definitely supports relevant Unicode code points, you can use these characters instead of relying on a legacy symbols font, while still having normal characters available. For example "Arial Unicode MS" supports CHECK MARK (U+2713) and HEAVY BALLOT ...


2

You could try a "script the script" approach by using the SQLCMD :out command to redirect output, with :connect and optionally :r to read the output, something like this: SET NOCOUNT ON DECLARE @tbl TABLE (Id int IDENTITY (1, 1),ServerName sysname, DbName sysname, IsDone BIT DEFAULT(0)) INSERT INTO @tbl (ServerName,DbName) VALUES (N'CZASQL-001', ...


1

SSMS has no equivalent shortcut to the CTRL+B shortcut from Query Analyzer. In my opinion, the best alternate feature is the ability to have query & results in separate tabs. In this way, I can flip between full-screen query & results easily, and maximize screen real estate for both. To enable this in SSMS: Go to Tools-->Options... In the left ...


1

I don't think so. These settings are stored along with a bunch of other UI configuration in a binary file in your user profile directory.



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