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)
 last error

Author  Topic 

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-18 : 11:44:52
Is it possible to interegate SQL Server for the last error that it threw - regardless of which connection it was on?

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-07-18 : 11:50:49
maybe while running a profiler trace.
Go to Top of Page

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-07-18 : 12:21:10
ummmm. the error log.

Sean Roussy

Please backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.

I am available for consulting work. Just email me through the forum.
Go to Top of Page

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-19 : 04:07:45
You can't really interegate a sql error log file with great ease from inside a script though. I was thinking more of a global @@error...
Go to Top of Page
   

- Advertisement -