Good catch, Sean. I didn't even...

My best suggestion would be to use a Data Flow task to insert various items to evaluate the final row, then used Derived Column tasks to add the final blank...

I don't know that it will continue where it left off.

But did you verify that SQL Server Agent is set to restart automatically (at the Agent & service level) when...

Luis, you are a better person than I am. I have no desire to keep encouraging the OP to ask for the query, so I am not answering at the...

IP addresses have nothing to do with the drive the files are on and everything to do with the NICs in the servers / assigned to the servers.

That being said,...

Sorry, I don't provide queries for homework. Please look at what I previously said about breaking down the problem and try it yourself.

You could write yourself a data dictionary report in SSRS that would pull all dependencies on each object. Then refer to that report every time you go to make a...

Check the windows events logs for errors and warnings around that time. Also look at the information messages. What is going on at the server / OS level during that...

Are DB1 & DB2 on the same server? If not, run a hardware check. I can't count the number of network issues we had because a NIC was going bad....

Jagdev, post a new thread and detail your issue a little more.

People don't tend to respond to older threads.

Have you seen this solution[/url] at Simple Talk?

I haven't used it myself, but it looks interesting.

Scott, that is an awesome explanation.

Or there are mitigating...

You have to create something specific to...

My advice is two-fold.

First, don't try to shrink while other people are using the database. Find a maintenance window. Change the db to Single User if you have to. Keep...