Just wanted to mention that this thread saved my butt. I had a proxy account set up on a server whose domain controller went south. When they rebuilt the domain,...

Thanks for the reply, Asif. I don't know about other technical people, but my time is very limited, and I pick and choose what I read in order to enhance...

It's unfortunate that this article is loaded with typos and grammatical errors. I stopped reading it, because I don't have time to translate what the author is trying to say....

I decided to go with Rambabu's suggestion to save the script in UNICODE, as it was the easiest to implement. That worked great!

Thanks, everyone, for your replies! All were good...

You can call another job using the stored procedure call msdb.dbo.sp_start_job. I use this sp to start another job on another server and it works fine. Read Books Online for...

I've had the same experience in my shop, and am even banned from using Profiler now, which is unacceptable to me. I've searched Microsoft's website for any help, and can't...

If you are running on SQL Server 7.0, sp3 or earlier, your data file may increase after shrinking it, if you have tables containing binary information. This is fixed in...

If you are running SQL Server 7.0 with sp2 or sp3 and are trying to shrink a database that contains text or image data, there is a known bug that...

I use SQLLiteSpeed in my shop and highly recommend it as well. Our database backup file is normally around 35 Gb, but is compressed down to 8 Gb when backed...

David,

I have been using your script for a few months now, and like it a lot (thanks!). Unfortunately, it doesn't capture any objects that were ALTERed, which is one of...

I'd say I qualify as a typist - however, I never really mastered the top line (the one with the numbers) without having to look. Funny, how you'd think that...