Viewing 15 posts - 2,836 through 2,850 (of 6,216 total)
One connection or more really depends on what you're trying to do. If you've got a long process you need to run, makes sense to open an extra connection for...
December 17, 2002 at 10:55 am
Brian has been a frequent contributor in the DMO discussion area and of course we've been glad to have Lockwood Tech as advertisers here on the site. They have some...
December 17, 2002 at 8:58 am
December 17, 2002 at 4:57 am
Depends on whether you need a perfect copy or not. If you're just want to mirror some databases, no need to restore master. Just do the restore (and then resolve...
December 16, 2002 at 5:08 pm
Process is correct, should leave a command window open with a line saying something about recovery being complete near the end. If you don't see that, then you can't proceed...
December 16, 2002 at 4:13 pm
Not getting an error when I run it. Which DMO library are you using?
Andy
December 16, 2002 at 10:37 am
Steve, Brian, and I met several of the team from DBAssociates at Pass - great guys! You don't have to talk to them long to see that they worked to...
December 16, 2002 at 4:48 am
Firewall if you have one, on either side. Can you connect using QA? Using trusted connection? Verify that SQL is really listening on the port, sometimes it wont if there...
December 15, 2002 at 8:12 pm
Tested connectivity, can you ping the server from home? Someone changed open ports recently?
Andy
December 15, 2002 at 5:07 pm
Its not supposed to decrease. SQL will try to use all memory allocated to it for caching of data, query plans, etc.
Andy
December 15, 2002 at 2:39 pm
Still not sure I understand. When you issued the kill, did the spid begin rollback? Not affected at all? Are you sure the app server didnt immediately reconnect and establish...
December 14, 2002 at 6:23 am
Why couldnt you kill the processes? Were they system spids? Taking the server down without letting SQL finish checkpointing should definitely be a last resort. One of my servers takes...
December 13, 2002 at 3:28 pm
Nothing wrong with your idea, using AD does reduce the overhead needed to maintain access. If you're going to do this, you either live with the potential security gap I...
December 13, 2002 at 3:26 pm
My first question - are you just defining roles for the application, or true "application" roles as defined by SQL?
Having an admin and a readonly role (regardless of type above)...
December 13, 2002 at 2:14 pm
ODBC trace is turned on/off via the DSN applet in control panel.
Andy
December 13, 2002 at 4:49 am
Viewing 15 posts - 2,836 through 2,850 (of 6,216 total)