use exec sp_executesql for it.

refer books online for the same

http://support.microsoft.com/kb/271509

go through the url it will help u.

keep a eye on cpu and memory utilisation also

hi,

in google i have found one sp named sp_blocker when executed on the desired server will show all dead lock chains wait type with their respective spids and also the...

ps (7/8/2009)

---

If you are entering same records in both publisher and subscriber, the record originating from the publisher takes precedence over the one originating from the subscriber by the conflict...