Praveen,

Thanks for submitting this, and it came out very well. I'm sure you're helping more than a few people with this.

Closing the thread. We can discuss in the other thread.

Marking something as "answered my question" is something we're considering.

The rating thing, hard to know. I think if you consistently answer poorly, others join in and let those that read...

That's an interesting idea. Not sure how it will work with drywall and the studs, but something to look at.

and like those investing now, if you invest in BI now you'll likely be much better positioned to take advantage of things when the economy recovers!

Clive,

Is this required? Do you log/record this as a part of your job?

You need to use an account that is a local administrator.

I think Teradata got migrated to 7. Not sure after that.

3 pound bone?!?

I want a picture.

Transformation and stimulus aren't exclusive, but any money moved towards helping broken areas, i.e. auto industry, needs to be limited and needs to push them forward into new models. I'm...

Expiredate isn't a delete. It allows rewriting of the file. If you put multiple backups in ONE file. meaning you have sales.bak and it has backups for last night and...

checkdb, which should be regularly run, and error log checks (again, regularly scanned), will alert you.

What you do depends on what you find. Good suggestions above.

What's your xcopy string? It should run from the command line fine.

Also, how are you executing xcopy?

You'd have to write something. I had friend that built a "check" into the app to look for changes when it starts (or users click something).

The minutiae of how to...

Not yet. The list is at http://www.sqlsaturday.com. Feel free to bring this up in your user group and see if people will put one together.