Viewing 15 posts - 1,966 through 1,980 (of 6,216 total)
Not if all objects are owned by the same owner.
Andy
July 2, 2003 at 4:12 am
Steve, you might want to give us all time to wake up, read email etc.
Do you have something else accessing the table?
Andy
July 1, 2003 at 9:01 am
Easiest is to detach, rename the mdf, reattach just the mdf, let it create a new ldf.
Andy
July 1, 2003 at 4:04 am
Scheduled stuff is usually done by setting up a job in SQL agent. You could set to run at a certain time when you know the step before would be...
July 1, 2003 at 4:03 am
ADO stream object is the easiest. Search http://www.msdn.microsoft.com for sample code. I'll put up an article on it soon, it's a common question - not a bad one either.
Andy
July 1, 2003 at 4:01 am
July 1, 2003 at 4:00 am
You have to have cross db ownership chaining enabled and the user has to exist in the other db as well. SP3 would have broken this if you didn't check...
July 1, 2003 at 3:59 am
I'd say you probably need more memory. The page swapping is drive up your CPU load. Check drive IO while you're looking, it's probably high as well. All things considered,...
June 30, 2003 at 4:48 pm
June 30, 2003 at 4:46 pm
Not that I know of. Just index the field as you normally would, hope for the best. Its an interesting technique used for a lot of things, we had to...
June 30, 2003 at 4:39 pm
Always better to make one trip instead of two if you can. You can handle it by supporting 'x' sets of detail parameters in your proc, or you can build...
June 30, 2003 at 4:36 pm
Good question. To execute the job they have to be either SA or the owner. To run sp_addpublication they have to be sa or a member of db_owner. If you...
June 30, 2003 at 4:34 pm
I'd only do it if you couldnt get a full backup done within the amount of time you have to get it done. Need to start asking for more space...
June 30, 2003 at 3:37 pm
Subscribers should not have identity set to yes unless you're doing updating subscribers (or merge).
Andy
June 30, 2003 at 7:44 am
Or you're disk bound, CPU can't work until the drives catch up.
Andy
June 30, 2003 at 7:42 am
Viewing 15 posts - 1,966 through 1,980 (of 6,216 total)