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

could you suggest few procedures of how to check the index fragmentation and file fragmentation?

also, the deadlocks errors : error:1205, severity 13 occurs atleast 200 times a day in the...

I have not done it for that many on the same server but I know people who has done it for over 200+. So you are not anywhere near the...

the snapshot agent is the one that posts the "snapshot generated" on the distribution DB and from there is picked up by distrib.exe

if the subscribers are "pull" subscribers I know for a...

ALTER TABLE bvc_Affiliate

ALTER COLUMN [DisplayName] NULL -- allow nulls

ALTER TABLE bvc_Affiliate

ALTER COLUMN [DisplayName] NOT NULL -- do not allow them

Nothing without study is easy but once you get to practice and get your feet wet with the documentation is easy to handle. In this case you just set up...

because you are already in the undocumented world you should try:

select [Object Name], [Index Name]

from ::fn_dblog(null, null)

Note that ::fn_dblog is also undocumented and probably a wrapper of...

Handles are Windows tools to manage limitted OS resources like bitmaps, brushes, Fonts, etc... It does happes that Handles are a limmited pool also and when you load many apps...

Definitely possible. Do the tables overlapp ? If they don't then is pretty easy. If they do you should worry about PK collisions and reinitialization issues.

Cheers,

There are definitely many "details" different but if you master the core on 2000 there is nothing that prevent you from quickly use the new features.

These situations are tough and you should definitely learn from them.

Life is not Back or White there are a bunch of grays and you should balance your attitude. I...

this is just another reason to get rid of cursors ... 😀

Erm ...

waittime is in MILLISECONDS ...

select 2147483647 / (1000*60*60)

-- 596 Hrs

Great, glad it worked for you.

Unfourtunately can't help you on the "how it happened" 🙂 someone must have setup replication in it at some point but is up to you...