Try the MS link below...

Thanks Paul... Much appreciated!

Jonlee

Steve, sorry to hijack this posts... But if you have 15 minute logs backups and P2P replication could it lead to lost transations when the backup takes place and the...

See ...

Steve,

Any chance of getting 2008 SP1 CU7 on the list?

Cheers

You try setting the Db to single user mode and then restoring the DB

ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE

After restore..

ALTER DATABASE MyDB SET MULTI_USER

Please note that any...

No, it should give you the % per process per instance.

Use perfmon. Under the Process object you will be able to select sqlservr, sqlservr#1 etc. Then select the % Processor Time

1. Has user activity increased?

2. Have you created any new indexes as this is a sure sign when a db increases.

3. What is your backup schedule? Do you backup...

Have done a search for this error...?

In the connection string just add "Max Pool Size ="..

I would personally look at the application that is setting/creating pool size. In my experience it has been the application not...

Just a little note to add if your are going on a mass ramage to remove user tools.

MSDE (2000) and Express (2005/8) are installed as part of some product. I...

VBscript

http://blog.netnerds.net/2007/01/vbscript-enumerating-all-sql-servers-on-a-domain/

Try SQL Ping...

http://searchsqlserver.techtarget.com/downloadPage/0,295339,sid87_gci1135136,00.html

All transaction that changes articles in the merge replication (inserts/updates/deletes).

Any conflicts can be resolved within the replication monitor.

It sounds like the app that the subs connect to updates the data,...