ALTER DATABASE db1 SET SINGLE_USER
ALTER DATABASE db1 SET MULTI_USER
SELECT TOP 2
*
FROM sys.database_files
WHERE data_space_id > 1
Hopefully this translates in syndication well. Here’s the way LiveWriter has this listed now:
|
|||||
|
|||||
|
|
The Voice of the DBA
Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest
Live Writer - Paste from Visual Studio
This is a test of the plug in “Paste From Visual Studio”. I had this code sitting in SSMS and I did a CTRL+C to copy it to the clipboard. Then I clicked the “from Visual Studio shortcut that’s in my LiveWriter (image below) and this appeared.
ALTER DATABASE db1 SET SINGLE_USER Hopefully this translates in syndication well. Here’s the way LiveWriter has this listed now: CommentsLeave a Comment |
Posted by Steve Jones on 13 May 2010
Wow, works through syndication. Guess I have a new add-in
Posted by Dukagjin Maloku on 13 May 2010
Steve, you are infected from Jack Corbett proposal! Seems cool add-in to work with "Paste From Visual Studio".
Posted by Jack Corbett on 13 May 2010
The only issue is that for some reason the text below the code gets wrapped in a <pre></pre> as well. Otherwise it is great.
Posted by Jason Brimhall on 13 May 2010
That is considerably better than other plugins.
Nice.
Posted by Anonymous on 14 May 2010
Pingback from Twitter Trackbacks for SQL Server Central, Live Writer - Paste from Visual Studio - SQL Musings [sqlservercentral.com] on Topsy.com