Doh! I'm an ID-Ten-Tee

Corrected and here: http://www.zdnet.com/blog/service-oriented/when-processes-are-beyond-the-reach-of-automation/5332?tag=mantle_skin;content

Yikes!

Remind me not to ride the sky ride when I go down there again. Do not like heights.

I would agree with scripting things. I'd script out all jobs and then search/replace.

I would vote for the WROX book as a good place to start.

There is no easy way to do this. A database isn't like the file system where you search everything. A search across different tables requires different queries with separate FROM...

use a max() aggregate and a group by clause.

It's fairly simple, but it almost seems like this is homework. Try it yourself.

I see NULL mostly as a "we need to get this data" marker. We don't know why it's not there, don't know what's there, but we need something.

No, I don't think there are big issues. SQL Server is designed to handle files, even large ones. I think that you have some limitations around 2GB, but apart from...

Implement logging, read the logs. They will provide more information

I don't think we completely know what happened. That would be limited to a few people, but I think most reports agree he did not disclose passwords when asked, and...

Thanks for the vote. I would decline to serve.

As good a word (phrase?) as any.

I shall decline to post my word for the day

:w00t:

Thanks, Alvin. Appreciate the kind words.

Thanks. I shall decline to comment on PASS further at this time.