Remove old trigger remnant... SQL2K5

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Remove old trigger remnant... SQL2K5

Author

Topic

djseng
Starting Member

25 Posts

Posted - 2006-08-17 : 14:25:58

Have an old trigger that is an artifact from an older database instance which I seem to be have trouble getting rid of. I can see it in the sysobjects and syscomments tables, but no record of it exists in the sysdepends table. If anyone has dealt with this before, I would appreciate your help.

Thanks,
Dave

DROP TRIGGER tr_RecordUserChanges

Msg 211, Level 23, State 215, Line 1
Possible schema corruption. Run DBCC CHECKCATALOG.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

djseng
Starting Member

25 Posts

Posted - 2006-08-18 : 08:26:23

Pray for me as I venture into the land of Microsoft Tech Support.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-18 : 09:02:36

What did DBCC CHECKCATALOG tell you?

Peter Larsson
Helsingborg, Sweden

djseng
Starting Member

25 Posts

Posted - 2006-08-18 : 09:50:23

Nothing of consequence:


DBCC execution completed. If DBCC printed error messages, contact your system administrator.

djseng
Starting Member

25 Posts

Posted - 2006-08-18 : 09:56:05

Get a large dump into the server log when it run the drop trigger...

Adds 1000 lines of info to the server log. The following lines look to
be the juciest ones.

08/17/2006 14:16:22,spid179,Unknown,Possible schema corruption. Run
DBCC CHECKCATALOG.
08/17/2006 14:16:22,spid179,Unknown,* DROP TRIGGER
tr_RecordUserChanges;
08/17/2006 14:16:22,spid179,Unknown,* Input Buffer 90 bytes -
08/17/2006 14:16:22,spid179,Unknown,* ex_raise2: Exception raised<c/>
major=2<c/> minor=11<c/> state=215<c/> severity=23
08/17/2006 14:16:22,spid179,Unknown,* 08/17/06 14:16:22 spid 179
08/17/2006 14:16:22,spid179,Unknown,* BEGIN STACK DUMP:
08/17/2006 14:16:22,spid179,Unknown,* User initiated stack dump. This
is not a server exception dump.
08/17/2006 14:16:22,spid179,Unknown,**Dump thread - spid = 179<c/> PSS
= 0x4F0C15B0<c/> EC = 0x4F0C15B8
08/17/2006 14:16:22,spid179,Unknown,Using 'dbghelp.dll' version '4.0.5'
08/17/2006 14:16:22,spid179,Unknown,ex_raise2: Exception raised<c/>
major=2<c/> minor=11<c/> state=215<c/> severity=23<c/> attempting to
create symptom dump

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources