Here's the link that you need:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

There is no such table or mechanism to query for the 'PAST' information that you seek. Your only option is SQL Profiler - a great tool, but not for long...

Talk to your MOM Admin. There is a link on the MOM console for every error generated to a MS article. That's a good place to start. If that does...

Here's something I posted under another thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=253481#bm253802

I prefer a less hands-on approach. First off communication to the user community. Then I'll put the databse into 'read only'...

There is one other option - take the 5 day 2000 admin course. Then take a 3 day upgrading your 2000 skills to 2K5. In lieu of the 3 day...

I prefer a less hands-on approach. First off communication to the user community. Then I'll put the databse into 'read only' mode for a few days, maybe a week. If...

Here's a little something for all of the system tables ...

http://www.microsoft.com/sql/prodinfo/previousversions/systables.mspx

Do not forget the msdbdatabase. It contains lots of 'stuff' ... Jobs, Schedules, DTS package information ... Just having master and no msdb backup can really ruin your day (unless...

I've been in IT 23+ years, most of them as a DBA. After my first 2 employers (years 1 through 4 in my career), every successive one has offered and...

Sounds interesting enough ... but why ... the only user group I can think of to really want to 'take off' with this (aside from cyber-phobes) would be the terrorist...

It's really quite simple, it boils down to:

• 'pride of ownership' --> doing it right the first time
• ' rationalization'  --> political-speak for talking your way out of responsibility for something
• 'MBA Mentality' -->...

Have you looked into the application eventlog or the system event log ? If there is nothing there then possibly try re-installing the client tools. Also, even though isql is...

You can also mark multiple SP's as well. Multpile SPs are excecuted alphabetically I believe. So in order to enforce an execution order you'd have to name them accordingly.

In SQL2000 the 'if @@error' coding construct will work but is dependent on the 'severity' level of the error encountered and a 'set' option or two for the session.

SQL 2K5 has...

512 Mb of RAM is very, very small for a SQL Server with an application executing on it. If this were my SQL Server I'd pull out the stops and...