Testing for database name 1

[rhysmeister]

Is there a way to test for the database name at the top of a script so it will never run against the wrong one? I want something like...

IF SELECTEDDATABASE = <intended_database>
  Begin
    Do script actions
  End
Else
  Begin
    print "Error, this script is not permitted to run on this database!"
  End

 

[mrdenny]

Use db_name() to deturmin the current database. It will return nvarchar so you shouldn't need to convert the output to use it.

if db_name() = 'user_database'
BEGIN
  Do something
END
ELSE
BEGIN
  print 'Error'
END

Denny

--Anything is possible. All it takes is a little research. (Me)