I was able to get the script to execute. The code is as follows:

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic 2008.

' The...

Got it, thanks Dan!

Thanks for the response Dan! I've got a few questions though about it:

1. What do you mean by 'always get the code from the report server'? Is that...

Sounds good, thanks Steve.

That makes sense. I'm told that it's happened at my current employer that some column additions haven't made it over to the secondary server. I'm not sure how...

Several days ago I ran into the issue again and had to redo log shipping for about 40 databases. Fun.

When the crud hit the fan, there were tons...

Mark, can you elaborate on how I can look at the mb/sec for the restore? Thanks.

Awesome! Thank you Lynn.

Hello,

The following code works as expected (from BOL):

BACKUP CERTIFICATE [CertName]

TO FILE = 'C:\CertName.cer'

WITH PRIVATE KEY (

FILE = 'C:\CertName.pvk',

ENCRYPTION BY PASSWORD='password',

DECRYPTION BY PASSWORD='password'

)

GO

All three 'WITH PRIVATE KEY' paramaters appear to be...

Sorry for the delay in reply. It looks like Dave is correct for my situation. Adding up each line and comparing to the total shows that Profiler is...

I double checked to make sure I wasn't looking at two different event classes, and both are SP:StmtCompleted.

HTH

This is great information, thank you!

Perfect! Thank you Gail, I wasn't able to dig up anything using Google but completely spaced out BOL. DOH! Tks again.

Great, thank you very much. The file was not in the list generated by:

select physical_name from sys.master_files So, I went ahead and renamed the file and restarted the...

I added that user to the sql agent roles as you suggested but to no avail, I still get the same denied message.