server1 is 2000, server2 is s2005.  that's what  i was looking for... to migrate between versions.

Thanks for the replies.

I don't need the seconds.  How can I do just date, hour, minute.

Thanks for all the replies.  Very helpful.

thanks, guys!

Is this line the only one looking for caps?

ascii(substring(@new,@position, 1)) between 65 and 90 or -- A-Z --

Are these lines looking only for special chars?

ascii(substring(@new,@position, 1)) between 196 and 197 or        ...

I finally found a thread that pointed me to:

http://support.microsoft.com/lifecycle/?LN=en-us&x=15&y=14&p1=2852

I got it....

DBCC INPUTBUFFER (spid)

Data Source is SQL Server.

The screen print in the first post is the error that pops up.  When I click the 'More info' link I get this error:

Check to see if you have it set to Retry (on the advanced tab of the Step).  If so, set retry attempts to 0.

Thanks to all for the replies!

Lucky, thanks for the reply.  The problem is that I'm returning '5' when I really want '05'.

thanks!

I want to either use col3 or col8, but not both.

Is there a tape backup application (EDM, Legato, etc.) that is running at this time?  If the file is being backed up to tape at this same time, that would...

Daniel, thanks so much. I must've had a brainfart...it didn't occur to me to change the db connection object. Once we did that, it worked.

thanks!

Yep, the proc is executed in a sql task. What I don't get is if the developer is connecting to sql via a sql id, why does msdb not...