Except someone else will be in charge of it and they'll be bugging you for CPU counts, which is in which class, what the multipliers are, etc.

Plus it's not...

Bill,

no idea, but I pinged Brian Kelley. He's probably got an answer for this.

If someone activates the role, then they are treated the same. I believe you'd need to disconnect and reconnect to change this.

If someone does steal the pwd, then they could...

Backups: Native SQL works great and is bulletproof. If you have lots of data, however, then you might want to look at Red Gate, Quest, Idera for a compression utility

Log...

You could probably backtrack using a log reader (Apex, Lumignt, LogPI), but not sure it would be an easy answer. Might need to run reports from their products and then...

You cannot assign a rowset to a variable. They are different structures internally and it won't work. I believe that you are assigning the return value from sp_executesql to your...

Perhaps the UDF call takes precendence over the funciton call, so it's not a datetime when it's passed ?

Not sure

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...