Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-08 : 08:59:25
|
Steve writes "Bottom-line Tech Need:
I want to overwrite a system error (7343).
I want to set the dlevel to 0 rather than 1.
I know you can do something like:
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'allow updates', '1'
go
RECONFIGURE WITH OVERRIDE
and then:
update sysmessages set dlevel = 0, description = 'You bet ya' where error = 7343
You then see the changes in the sysmessages table but SQLServer knows your an idiot and uses its true system table to retrieve this information, thus I receive a 'fatal' error.
Total Bottom-line:
Where/what the heck are the base system tables, so I can do some real damage and really change the dlevel to 0.
Great thanks...
" |
|
|
|
|
|
Change erros dlevel value