Viewing 15 posts - 38,461 through 38,475 (of 39,754 total)
Try this. Not sure it is the best or always works.
create table MyTable
( MyID int
)
go
insert MyTable select 1
insert MyTable select 3
insert MyTable select 5
insert MyTable select 12
insert MyTable select 15
insert...
January 29, 2002 at 12:39 pm
Brian has a good explanation for Nulls.
BTW, for items like job, where I might not use the information for people, I tend to normalize this, so instead of having a...
January 29, 2002 at 12:30 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
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
Viewing 15 posts - 38,461 through 38,475 (of 39,754 total)