It's not possible to delete threads. You can either report it and ask the mod to delete it, or edit it and put a link in pointing at the correct...

Max bcp threads is for the snapshot agent and is concerned with how many threads are used to generate the snapshot. It's got nothing to do with the log reader...

Please don't cross post. It just wastes people's time and fragments replies.

No more replies to this thread please. Question has already been answered - http://www.sqlservercentral.com/Forums/Topic600722-145-1.aspx

And please don't cross post! It just wastes people's time as they answer questions that have already been answered.

No more replies here please. http://www.sqlservercentral.com/Forums/Topic601230-146-1.aspx

Don't backup to a network drive. It's slow and if the network glitches the backup will be useless. Backup locally and then copy the backup to the network drive.

Animal Magic (11/12/2008)

---

Thanks for the quick reply Gail, its the transaction log on the publicated database. I have just found out one of the developers has indeed run an...

Use Enterprise manager to generate a script that contains all of the procedures and then do a find and replace. Even if you have to check each location before doing...

You can backup at any time. The backup adds load to the system, but it doesn't lock any objects.

goodguy (11/12/2008)

---

I'm not a pro like all the others who have already ventilated this thread, but what I would do in this case is restore a backup on an independent...

Is the transaction log growing or is the error log growing?

Did that happen straight after an index rebuild, by any chance? Or an alter table statement?

Please post SQL 2000 related problems in the SQL 2000 forums. If you post...

Duplicate post.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic601216-149-1.aspx

Do not, do not, do not ever directly update the system tables. Doing so is asking for big problems in the future.

Generate the scripts of the procedures, search and...

Network latency

Can you please post the table structure, some sample data and what you want as a result?