Search code examples
sql-serverdatabaseopen-sourcedevtools

SQL Server Prevent Scripts Being Run on the Wrong Instance

This is less of a programming question and more of a suggestions for tools one :-)

I'm looking for a way to prevent scripts being accidentally run on the wrong sql server instance, ie so you don't run that script for clearing down customers in your development environment on the live/production environment.

What I'm basically after is a pluging for Enterprise Manager (or a different app for managing a sql server instance), that would allow me to define a list of connection details for SQL server instances, so that when the window is connected to a LIVE environment that it makes it quite clear, either by coloring the tab red, or by poping up a message box saying "This is connected to XXXX instance. Are you sure"

Asside form being really careful, does anyone have any ideas for tools/plugins that will do this or anything remotely simular?

Thanks for any help

Solution

  • here you go: http://www.ssmstoolspack.com/

    this free SSMS addin provides windows coloring per server.