Michael,

EDIT again: I take back everything I just said. I forgot to re-login. Crap. What was MS thinking when they did this?

I just tested impersonate. You're working off an invalid...

I'll double-check the impersonate, but when I logged in as the SecurityAdmin account, I was unable to grant actual SysAdmin to my own account.

Edit: Changing my answer.

It's a semi-good point. A user with every other permission cannot grant herself sysadmin access even when she has SecurityAdmin perms. Which is good from a security...

Have you used the multi-server admin tools yet? That's my primary interest in R2.

Well, I'm glad you found what could be the error.

I'm a little confused as to why you need to take liberties with the code for SSIS. Usually, you just need...

Rocky Horror Picture Show

Showing at a theatre near you... Though I do believe Comcast advertised it for a local channel last weekend...

Thank you for the information on costs. I hadn't seen that either.

jez.lisle (10/26/2010)

---

EDIT: You may also have to put the -S + @@ServerName before the -T. You need the server to log into before the credentials, I believe. But test it...

Thanks, Michael. I know what the fixed server roles do. What I'm trying to figure out is what they might not cover that would be necessary for a DBA who...

Glad I could help.

Do you realize your specified field terminator is not the same as what's in the file?

You're specifying a comma. The field terminator appears to be a semicolon.

EDIT: You may also...

Sorry I wasn't able to help you further.

Halloween

You really need to find out why the backup is being blocked. Check your error logs, check the default trace, run a server side trace, whatever you have to. But...

pitcher166 (10/25/2010)

---

Dynamic sql is not bad in any case. You should try dynamic sql perhaps if the execution plan inside a proc is suboptimal. With dynamic sql the statements within...