nito8300
asked on
Change Error Message
Hi All,
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)
Connection failed:
SQLState: '08004'
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been denied
I used the following code:
use master
exec sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE
update dbo.sysmessages
set description = 'Server is currently unavailable...don't panic!'
where error = 4060
exec sp_configure 'allow updates',0
RECONFIGURE
But I still get the same message.
Any ideas? My next guess is it can't be done.
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)
Connection failed:
SQLState: '08004'
SQL Server Error: 4060
Server rejected the connection; Access to selected database has been denied
I used the following code:
use master
exec sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE
update dbo.sysmessages
set description = 'Server is currently unavailable...don't panic!'
where error = 4060
exec sp_configure 'allow updates',0
RECONFIGURE
But I still get the same message.
Any ideas? My next guess is it can't be done.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the post. Most of the user access the SQL Server thru ODBC - that's what I'm trying to customized.