http://msdn2.microsoft.com/en-us/library/ms143432.aspx

Like "restore a database to a different location"

DR type tasks are usually good practice projects for DBAs to get better at their job.

Haven't applied SP1, was waiting for you

I'd try Mike's idea and let us know.

If CheckDB fails, I'm not sure it will fail the job. You can use "with table results" and store the answers for a job to scan them later.

I'd BCP or...

The task 17 is definitely causing an issue with your package.

The problems with the questions are hard to deal with becuase it requires multiples sets of eyes willing to proof them. I might get someone to do a few, but...

Apologies!!

It's my fault. I forgot to cut and paste a portion of the question, as you may have guessed. It was a busy day yesterday and I didn't re-read...

The "owner" is a hard question. Really the person who bought it owns it, but they have limited rights. In the US, they have "fair use", which includes copying for...

Sam,

Interesting thought. I thought my most successful IT group was one where we released a new version (web apps) every Wed, tackling things that could be done in 1 or...

touche!

It's changed

I'm not sure it matters how the technical order of the restore goes. Once you start a log, it will complete as a single unit or work. It will work...

http://www.sqlservercentral.com/columnists/lPeysakhovich/anaudittrailgenerator.asp

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart4selectiveauditing.asp

Not to be difficult, but are you double checking to be sure you're looking at the right db? I've made that mistake before.

Also, is there a lot of insert/update/delete activity...

Need to have "go" between the statements. A create table needs its own batch

How are you trying to "connect" between the systems?