Viewing 15 posts - 38,431 through 38,445 (of 39,720 total)
Andy is away and I'm sure he has some. One nice thing is that in DMO there are methods to accomplish many tasks. In ADO you will have to code...
January 29, 2002 at 12:22 pm
January 29, 2002 at 12:11 pm
Don't have an NT workstation handy. We are all W2K and I wouldn't be surprised if NT is the issue for remote debugging.
On my servers that allow debugging:
W2K, SP1 Server....
January 29, 2002 at 12:05 pm
Don't believe so. you'd have to test it, but I believe that they can directly. BOL shows most procedures need syadmin roles setup.
You could create a job for people...
January 29, 2002 at 11:58 am
January 29, 2002 at 11:48 am
January 29, 2002 at 11:45 am
January 29, 2002 at 11:43 am
You will have to do it yourself somewhere. sp_help (table) will do it, but will return multiple result sets. You can recieve and process these in ADO.
Steve Jones
January 29, 2002 at 11:35 am
That is correct. There are a few places where you can get decrpytion routines (hence these are not that secure). Is this version v6.5 or v7/2000?
Steve Jones
January 29, 2002 at 11:32 am
I'd do the backup if you don't have the time.
If you do, try the detach, attach
Steve Jones
January 29, 2002 at 11:30 am
I think the consensus is to let SLQ manage the memory. If one server is not getting what it needs, I'd add memory before messing with the settings.
Steve Jones
January 29, 2002 at 10:55 am
It should work, but I'm always a little nrevous about moving between versions with something like this.
Steve Jones
January 28, 2002 at 5:08 pm
I personally disklike the cascading deletes. Maybe I'm cautious, but I prefer that the rows be explicitly deleted.
Steve Jones
January 28, 2002 at 5:07 pm
January 28, 2002 at 1:31 pm
Excellent article Brian. It is one of the best written articles I have seen on stored procedure execution on the server.
One issue I was wondering if you'd look at...
January 28, 2002 at 1:30 pm
Viewing 15 posts - 38,431 through 38,445 (of 39,720 total)