Viewing 15 posts - 1,231 through 1,245 (of 4,272 total)
From what you are explaining I don't think your problem is a cluster restriction as much as not understanding how the cluster works..
You say the F and G drives are...
July 6, 2011 at 3:02 pm
You can only suppress configuration warnings.. there is a package level option for that. Other warnings, no..
CEWII
July 6, 2011 at 2:54 pm
Is this a one time deal?
If so don't bother with a ForEach loop, I'm not sure of a good way to do it that way anyway..
But with only three it...
July 6, 2011 at 2:48 pm
Coming back in a little late to the discussion..
Jeff, business users won't take ownership unless you make them. In a former employer we made them take ownership...
July 6, 2011 at 2:43 pm
While I agree that this method would work my own experience shows that anytime you need to query more than a single value it starts to get complicated. And...
July 6, 2011 at 2:00 pm
Glad to hear your first day went well. And cost is pretty much always going to be a complaint.. Nothing you can do..
Good luck..
CEWII
July 6, 2011 at 1:47 pm
I've seen cases where permissions changed but running processes didn't not recognize those changes. Did you have to grant the SQL login admin level access? Have you restarted...
July 3, 2011 at 1:56 pm
I don't see a linked server being necessary at all.
If the requirement is a once a month sync then a restore is probably the simplest. The other...
July 3, 2011 at 12:44 pm
You don't unless it is totally manual.
CEWII
June 30, 2011 at 9:26 pm
bubs (6/30/2011)
That seems to all be working fine now. Now on to some encryption questions.. 🙂
There are definitely...
June 30, 2011 at 3:37 pm
Craig Farrell (6/30/2011)
"What moron designed this tragedy?"
I got pop in my nose.. That was pretty funny, and I absolutely NEVER recommend using anything even close to this.. In...
June 30, 2011 at 3:15 pm
Still, I want to know WHY..
CEWII
June 30, 2011 at 2:52 pm
Mhlewis (6/30/2011)
June 30, 2011 at 2:34 pm
dean.g (6/30/2011)
SQLkiwi (6/30/2011)
Code sprinkled with index name hints and (nolock) in particular is rarely good code, in my experience at least.
That was my gut feeling. We have members of...
June 30, 2011 at 2:29 pm
Keep in mind temp tables will always be created in tempdb. I am also curious why you care what database they came from? You can't do anything with...
June 30, 2011 at 2:22 pm
Viewing 15 posts - 1,231 through 1,245 (of 4,272 total)