Rename or comment Sql Server's databases

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Rename or comment Sql Server's databases

Postby Andrei.Amza » Thu Feb 10, 2011 3:16 pm

Hi,

I think it would be great if you could rename a "server.database" object (like an Sql Server Alias --> ComputerName\\Instance\\Database) or leave a comment near one, like a label. I could use that to know exactly on which computer I'm running a script instead of adding:
SELECT srvname as Server FROM master..sysservers WHERE srvid = 0

Thank you!
Andrei.Amza
 
Posts: 1
Joined: Thu Feb 10, 2011 3:00 pm

Postby chriskelly » Fri Feb 11, 2011 6:15 pm

Thank you for your suggestion. There is an Enhancement Request for this feature, reference: SRP-3021. The developers will take a look at this soon.
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests