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...

What is your connection string? How is it different than local access? Perhaps an incorrect protocol?

Have you run profiler to see if there is a connection from somewhere else?

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...

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...

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...

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...

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.

Follow Martin's advice.

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...

Did you check the log? Are you sure the job is running, check history, enabled, etc?

Buy a bigger box

The timeout occurred because the db and web were on the same box and we were getting overloaded. We separateed...

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.

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...

I agree with Jeff