My point was not to insult you, but recommend a product since this is easy to make a mistake on and end up wasting lots of time.

At the same time,...

Could you provide an error message or the relevant portions of the package log?

Please write a full question in your post and provide information for people that are scanning the forums. The full title doesn't appear and we are not using that to...

Use sqlcmd instead. It can send all output to a file.

You mean we outsource, hire contractors who should be experts and we have to manage them!?!?!!?!

I thought we could turn them loose and we'd get great results 😀

We use Camtasia for the videos here. Works well.

Be sure you get a USB mic.

Indeed, my guess is Jeff if handcrafting something right now in the winter snows of MI.

It sounds like you really don't know a lot about SQL Server. Honestly the safest thing would be to get the money to buy Data Compare from Red Gate and...

There are quite a few scripts on this site that will rebuild indexes based on fragmentation and fillfactor that you can use.

http://www.sqlservercentral.com/search/?cx=000517265726492607871%3Agqdiynsp-y0&cof=FORID%3A9&q=rebuild+indexes&sa=Go#1161

That works if you're restoring same server, but if this were DR or on another box, you wouldn't know, would you?

You have a few things to check here and I might break it down into a couple queries and union them.

Each would join rows with first name matching.

1. would join...

Be sure you read a bit to understand what you're doing and don't just run the code. You could get yourself into trouble.

If you have more questions, specifically about your...

I don't think there's a way to reset the LSNs and as Gail mentioned, you can't detach/attach.

My guess is only another full backup will work.

If it's not in the logs, I think you're stuck.

http://msdn.microsoft.com/en-us/library/ms187408(SQL.90).aspx

There's one "D" in update.