Nothing new :-). The *.vbs files are to be created via NOTEPAD, and simply double-clicking the file should be...

Had a quick look at the script - it is a VB script that does pretty much the same thing - iterate through and export all available DTS packages as...

A little bit of manual intervention will be required, but the search will be automated. Here's how:

1. Open the DTS package in the DTS Designer

2. Save the package as a...

Good one! I had to refer BOL for this one because we don't use Bulk-logged mode, but it was fun learning something new today. Thank-you!

Tom.Thomson (2/14/2011)

No, in...

Hello!

This can be done in two ways:

1. Have a check-sum column. Compute the checksum of the row and if the checksum is different from the stored value, something changed

2. Try...

I agree with Gail.

Anyway you can have a second drive attached to the server? That way, you can have the database (or part of it) restored there for the cleanup...

You also need to shut down the SQL Server instance, remove the single-user mode parameter and then restart the instance to complete the restore.

Is this where you are facing the...

Good question, Hardik! Thank-you.

I guess it's more of how one has grown up with things. When I was in school, one of the "skill" subjects that we had was typing (the good, old...

Hello, Tejaswini!

It's okay to be confused. Not a problem. I appreciate the fact that you asked for more clarification.

The point illustrated by #3 is, in itself the answer to #4....

Thinking in even more detail, I believe the definitions vary between on-premise and hosted deployments.

In my opinion, hosted environments need to include both the scheduled & unscheduled downtimes in their...

I do believe that scheduled maintenance windows should not be counted in the uptime guarentee because of the same reasoning mentioned in the editorial - scheduled maintenance windows are planned...

You can think of using the "EXECUTE AS" option. In this scenario, the stored procedure will be executed after impersonating as whatever user you mention.

Hence, you can have a user...

Hats off to you, Paul! Excellent article. Very beautifully explained via the use of a nice, gripping story that evolves itself into shape.

Thank-you!