Viewing 15 posts - 7,081 through 7,095 (of 9,725 total)
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...
October 26, 2010 at 8:19 am
Have you used the multi-server admin tools yet? That's my primary interest in R2.
October 26, 2010 at 8:10 am
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...
October 26, 2010 at 7:49 am
Rocky Horror Picture Show
Showing at a theatre near you... Though I do believe Comcast advertised it for a local channel last weekend...
October 26, 2010 at 7:45 am
Thank you for the information on costs. I hadn't seen that either.
October 26, 2010 at 7:43 am
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...
October 26, 2010 at 7:40 am
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...
October 26, 2010 at 5:38 am
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...
October 26, 2010 at 5:30 am
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...
October 26, 2010 at 5:14 am
pitcher166 (10/25/2010)
October 26, 2010 at 5:07 am
Pam,
Is there a reason you can't use SSIS to do this move?
October 26, 2010 at 5:03 am
And now it's time to start the upgrade discussion at my workplace. I think we might only be getting the regular version. I'd like to get R2 if I can,...
October 26, 2010 at 5:02 am
Viewing 15 posts - 7,081 through 7,095 (of 9,725 total)