Solved

Change Error Message

Posted on 2006-10-19
3
2,879 Views
Last Modified: 2007-12-19
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.
0
Comment
Question by:nito8300
3 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 250 total points
ID: 17768881
The SQL Server error messages are stored in the sysmessages system table.
However be aware that sysmessages is stored in the master database, and
affects ALL the databases, so if you have multiple applications using
multiple databases on one server, changing sysmessages will affect ALL the
applications.


Also be aware that sysmessages contains place holders for variable
information ... things like database names, table names, etc. Unless you can
structure your customized error messages to use the place holders in the
same sequence as they appear in sysmessages, you might be out of luck.

So I think, its a good idea not to mess up with system tables.
0
 
LVL 15

Assisted Solution

by:MNelson831
MNelson831 earned 250 total points
ID: 17768982
Probably much better to handle custom errors like this:

http://www.sqlteam.com/item.asp?ItemID=2841
0
 
LVL 9

Author Comment

by:nito8300
ID: 17774310
MNelson,
Thanks for the post. Most of the user access the SQL Server thru ODBC - that's what I'm trying to customized.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question