Viewing 15 posts - 38,611 through 38,625 (of 39,902 total)
Mixed feelings. I hate having something scripted that affects more than one table or update. It prevents you from handling changes to your application that you might not forseen. Maybe...
January 29, 2002 at 12:25 pm
Mixed feelings. I hate having something scripted that affects more than one table or update. It prevents you from handling changes to your application that you might not forseen. Maybe...
January 29, 2002 at 12:25 pm
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
Viewing 15 posts - 38,611 through 38,625 (of 39,902 total)