You can use an Execute SQL Task.

Use the Parameter Mapping pane to map your servername to a variable. Then in the SQL Statement you can reference that variable and...

Great article, thanks for your perspective!

Regarding backups, I did some quick testing...

I restored the backup to a different server. To use the Certificate and Symmetric Key I first had to open the Database Master Key...

Thanks for the response. I had tried that earlier and it did not...

Hi Brad,

Unfortunately, I can't say for sure exactly when the connections dropped and were subsequently able to be re-established. I was in our server room and it wasn't until I...

Bradley, thanks for the reply. This is a Win 2003 Cluster. I am completely certain all three groups - the cluster / quorum group, the MSDTC group, and the SQL...

Thanks for the suggestion Chrissy. I haven't had much reason to troubleshoot our cluster in the past so I was not aware of this log.

The log on the primary...

This confused me as well. I concluded the fields are defined as nvarchar,...

I believe Kerberos is more secure as it does not pass credentials around - instead it passes some sort of "ticket". But other folks can better speak to that. What...

If you do not want the user to DELETE, then you have to remove it from the db_datawriter role and create your own role, then grant the appropriate permissions to...

I think the first thing you want to do is understand precisely what is causing the deadlock - meaning what objects is each process requesting that is leading to the...

I'll assume you tested the query outside the context of sp_send_dbmail and there's no problems with the query itself...

One suggestion would be to make sure all objects are fully qualified...

Thank you for the response Michael.

I saw that AWE is only supported in Enterprise but I don't recall coming across any documentation indicating the same about /3GB...

When you say "converting", I'm going to interpret that as "copying"...

The 2 main options are backup/restore and detach/attach, based on whether the "original" needs to stay online.

If the original...

Thanks Geoff for the suggestion, but I'm not sure how that helps. The jobs are not objects that you can grant permissions to.

I may not understand what you are...