Viewing 15 posts - 3,481 through 3,495 (of 6,216 total)
Totally agree. Its a lot of variables, too many to be worth trying to guess, better to just test.
Andy
August 13, 2002 at 5:33 pm
Also depends on how often a checkpoint is issued.
Andy
August 13, 2002 at 5:31 pm
If you post the code would be easier for us to help.
Andy
August 13, 2002 at 5:29 pm
August 13, 2002 at 5:27 pm
If the first attempt to put it in single user succeeds, the second one will result in a trappable error. I'd recommend disabling the 2nd command button when the first...
August 13, 2002 at 5:25 pm
Everything concerns us! We try to keep up, but somedays there is just too much to do!
On the forums and overall, we've tried to avoid the one paragraph per page...
August 13, 2002 at 5:06 pm
Interesting. Hope you'll dig some more, I use linked servers a lot, just so much easier to admin than openquery, but in some cases it might be worth it.
Andy
August 13, 2002 at 5:04 pm
Single user mode should do that. Can you post some code?
Andy
August 13, 2002 at 9:49 am
I think one table makes sense. Or at least a view.
Andy
August 13, 2002 at 9:26 am
Dont know. Dont remember seeing a place to configure it. How much RAM do you have, what version of SQL?
Andy
August 13, 2002 at 5:12 am
Start my making sure you have scrun.dll registered on the machine where the package is executing.
Andy
August 13, 2002 at 5:03 am
Identity cols and replication are a trial. Merge is set up to work with them to a degree, letting you specify ranges for subscribers. Transactional doesn't have that flexibility. It...
August 12, 2002 at 7:11 pm
No problem at all. It's Books Online, the standard SQL help file.
Andy
August 12, 2002 at 6:33 pm
You can. If its a simple COM object anyway, dont think it would be very functional for one with tons of collections, just because the syntax is so complex. Take...
August 12, 2002 at 5:13 pm
Check to see if the default db associated with the login is missing.
Andy
August 12, 2002 at 5:12 pm
Viewing 15 posts - 3,481 through 3,495 (of 6,216 total)