Thanks all for the replies.

To clarify a couple of points. The variable is being used as a constant in the code. @yes will always...

Agreed, nothing is foolproof. I have a Carbonite subscription for offsite and a external drive with a sync toy transfer setup for onsite. I put my source in...

With a terabyte of storage for less than $100, free utilities like Sync Toys from Microsoft, and unlimited online backup services as cheap as $60\yr, I will never understand the...

I wondered about that. The SQL service is running under a local admin account. The permissions for the directory looked normal.

The trace could create...

Wow, 5 yr old thread answers the question I have today, especially the confio ignite comment 3 days ago.

Go figure.

Thanks,

Thanks for your help with this Gail. I guess I need to dig deeper and see what is causing the errors.

Maybe I'm reading this wrong then. Looking at the middle session, spid 67, it executed the xpLog_Info proc and also printed the ::ERROR::NOERROR line. I guess I would...

Below is the code that I used, there is a simulator running against the database and I had to filter down on some of the print messages:

PRINT '::ERROR::BEFORE'

Print 'SQL Error...

Yes, it's custom.

Thanks for all the help Gail. The problem comes down to the extended proc. No matter the value of the @RecordErrorNumber, that proc fires inside that if loop,...

Ok, so if I understand your last post, I would need something like this after every sql command

SET @ErrorNumber = @@ERROR

IF (@ErrorNumber != 0)

BEGIN

SET @RecordErrorNumber = @ErrorNumber

END

And then...

Thanks,

If I make a change and capture the @@ERROR after every SQL statement in the proc, with something like:

IF (@@ERROR <> 0) AND (@ErrorNumber = 0)

BEGIN

SET...

Thanks for the input. I will see if we can apply SP3 or if they want to limp through the holidays.

Thanks, I've read the kb article. We're not using FTS. Reading down through the doc Microsoft first fixed the issue in SP1. Since we're at SP2 we...

We've used this in the past, not as good as Red Gate, but it's free.

http://www.devart.com/dbforge/sql/sqldecryptor/