Replication error

[ezecastle]

Hi, we had an issue with our data warehouse where we get the following error.

exec dbo.sp_table_validation @table = 'tabelname', @expected_rowcount = 1214384, @rowcount_only = 1, @full_or_fast = 2, @shutdown_agent = 0, @owner = 'dbo'
General network error. Check your network documentation.
Communication link failure

We found that this procedure was causing blocking on the DB server which killed replication. Does anyone know how this procedure is called or what calls it? I haven’t found any information on it except what BOL has.

Thanks for your time.

[rmiao]

You can trace it in profile, enclude user name, app name and host name to trace.

[ezecastle]

Thanks, I will give that a try and hope I catch the issue.