Viewing 6 posts - 31 through 36 (of 36 total)
Is your instance in mixed mode? If it is, you also have to supply the SA password for the repair.
October 27, 2009 at 4:00 pm
Okay, that seems inline with my testing. It's hard to be sure sometimes, due to the almost black magic nature of resource scheduling, especially when multiple procs and such...
October 23, 2009 at 12:07 pm
Nevermind, I figured it out finally. Since different domain accounts run SQLAgent on the different servers, I had to give those accounts the db_ssisoperator role on the master. ...
February 6, 2009 at 2:34 pm
Thanks SQLBot, scripting it is. I was hoping to dumb down the process so anyone can do it all through SSMS' GUI, but sounds like that's not really in...
October 20, 2008 at 11:58 am
Thanks for that list of gotchas, Chris. And Gail as well. We use cursors all the time in Oracle, yes.
One additional question related to schemas. Gail, you...
October 3, 2008 at 3:54 pm
I like that, as far as making it easier on me, but one question. I warned you I'm having trouble wrapping my brain around SQL schemas 🙂
If we did...
October 1, 2008 at 2:44 pm
Viewing 6 posts - 31 through 36 (of 36 total)