I would like to customize some error messages on my SQL box so that when i'm doing maintenance and i disable access the users don't panic.
one error is: (when I restrict the db)
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been denied
I used the following code:
exec sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE
set description = 'Server is currently unavailable...don't panic!'
where error = 4060
exec sp_configure 'allow updates',0
But I still get the same message.
Any ideas? My next guess is it can't be done.