Yep. I checked for non-null values and my results were good. I just found a document (KB814509) that speaks of a bug with the is null clause in a where...

Official word from MS

"As you probably know this is a system-generated stored procedure. It is

placed in the target DB when a subscription is created and initialized for

replication. The name, parameter...

The original stored proc that was created during the setup process is still intact. I only had to add the new column to the sp. Really I was just trying...

It is a very good tool for visually looking at most all SQL Server and Windows OS related performance counters (the new version has the OS piece included). I have...

Thanks. I think that will help.

Rob DeMotsis

Sr. SQL Server DBA

This problem was occurring on my replication as well. I found that at the end of the push/pull, that the indexes for all the tables were being created and causing...

OK everyone, here is the skinny on the solution. Changed population mode from full population to change tracking and update index in background. The item count for the catalog is...

Thanks for the feedback. I checked the task manager and I guess I should include what I found there.

The mssearch.exe is not really at 100%. It is a combination...

Not really any issues. The replication works fine after all is finished. I checked my net I/O and Disk I/O at the time of replicating and all seems fine as...

Merge type. About 17 gig is the size of the replicated db. The snapshot takes about and 1 hour 15 min. The merge takes about 5 to 8 hours.

Rob DeMotsis

Sr....

Thanks everyone for the feedback. I think I can now identify ny indexes and handle the rebuild requests a little easier, now that I know where and what they are.

Rob...

Thank You gentlemen for your replies. The reason for the question is this. We are using IBM's flash backup and restore of Windows volumes in a 2000 environment. The only...

I have found a couple of ways of accomplishing this task.

Everything is explained here in the Microsoft SQL Server 2000 Failover Clustering Whitepaper found at

http://www.microsoft.com/SQL/techinfo/administration/2000/failovercluster.asp

Rob DeMotsis

Sr. SQL Server DBA

Pier 1...

In addition to my original posting. I read somewhere a while back that there could be a conflict with SQL Server and IIS on the same machine that could cause...

That is exactly what we do here as well. It works out when trying to keep everything organized.

Rob DeMotsis

Sr. SQL Server DBA

Pier 1 Imports, Inc.