Is it possible it is a permission problem?  I have had cases in the past where the security group changed the permissions of the account I was running the agent...

Any chance you are replicating the database?  In which case I have seen similar problems.  Also if you have a process running that requires a large log (I've done several...

Yea,  I had seen that option.  I was just hoping that there was something a bit more elegant.

Thanks

Ken

To the best of my knowledge usually.  The datasource can also be a file path and I have seen it be an IP address before as well.

Ken

Unfortunatly I can't give you the script myself because I wrote it for my current job and don't want to get in trouble

That...

The only difference I have been able to find is that the ones that work are on Windows 2003 and the others are on Windows 2000.  I have sysadmin rights...

Here is another way.  I'm not sure how efficient it is but it does cover your example and a few others I thought of.

Basically I'm looping through the table setting...

Ok the code works great.  On 2 of the 5 servers I'm running it on.  On the other 3 I'm getting the error " A dynamic link library (DLL) initialization...

Thank you very much!

Probably one of the coolest scripts I've ever seen (that I didn't write myself of course).  The shell from...

Unfortunatly my best bet is whatever you do is going to take awhile.  Also you are going to chew threw alot of space doing it.  However one piece of advice...

Please note that I say this without any information on your code, keys, server etc but when you killed the blocking process if it was a long running piece of...

Personaly for the inserts and updates I like to add a handful of columns at the end of the row.  For example CreateDate, CreatedBy, LastUpdateDate and LastUpdatedBy.  I create them...

Ryan,  While I seriously diagree with alot of the things said on this thread you have to understand where alot of the confusion came.  The title of the thread is...

Ryan,

I agree whole heartedly with John.  While what you did is highly unusual I've certainly seen and done some strange things as well. 

Just as a quick overview for you...

This requires a bit of a redesign but worked fairly well for me in the past doing shift calculations.  We stored our time data in an int column.  We then...