Viewing 15 posts - 33,706 through 33,720 (of 39,736 total)
I don't know where the party is as PASS is still organizing things with the Gaylord. It willl be Tues immediately after the opening reception from PASS. I think it...
August 25, 2005 at 6:30 pm
What is your connection string? How is it different than local access? Perhaps an incorrect protocol?
August 25, 2005 at 11:35 am
Have you run profiler to see if there is a connection from somewhere else?
August 25, 2005 at 11:34 am
Be sure you are not using AWE, some issues with SP4 there and I'd scan Google and be sure there are no other issues. Might want to test if possible...
August 25, 2005 at 10:18 am
I'm not sure you want to do this in ASP since the time could be long and you may get timeouts. Better to use ASP to insert a value into...
August 25, 2005 at 10:16 am
Peter is correct. No relationships across dbs.
If you want to use a trigger, I'd suggest using a view in case you do something else with the other db. Then you...
August 25, 2005 at 10:14 am
I like Phil's suggestion. You need to break the conversion into batches, which will not fill up the log in simple mode, or run a log backup or dump between...
August 25, 2005 at 10:12 am
This would not work with QA or any scripting tool. In the stored procedure, do not use hte "go" keyword. Just put the 3 index creates.
August 25, 2005 at 10:11 am
Grant all I believe just grants them to all objects and you still have to specify the permission.
I think ALL is a bad idea. It would be better to script...
August 25, 2005 at 8:12 am
Did you check the log? Are you sure the job is running, check history, enabled, etc?
August 25, 2005 at 8:12 am
Buy a bigger box ![]()
The timeout occurred because the db and web were on the same box and we were getting overloaded. We separateed...
August 25, 2005 at 8:09 am
Never thought of that, but it's a good idea. That page is being rewritten, but I'll look to add those in as well.
August 25, 2005 at 8:07 am
Tatsu,thanks, forgot to add this thread last night ![]()
I've had a few people email that this started in the UK (those clever Englishman and...
August 25, 2005 at 8:04 am
Viewing 15 posts - 33,706 through 33,720 (of 39,736 total)