you can use the exist method of xml to search the data

you can use it.

in sql 2005 we have so many ways u can list out the requird objects,

u can get the list of procedures using..sys.procedures

1. By maintaining the proper commenting in the SP itself.

2. By Genrating script & versioning it after each changes

3. BY mainting ddl trigger to check the SP audit.

😀

I think there is no such script, bu tyou can create the DDL trigger on database to track the records

U can try this way,

Add one column Timestamp in Server A - Table, having datatype Timestamp ( binary format )

Add one column Timestamp in Server B- Table, having datatype binary

and...

Could you tell us what kind of variety of errors is coming?

IF OBJECT_ID('tempdb..#tmp1') > 0

DROP TABLE #tmp1

CREATE TABLE #tmp1( ColID INT, ColName VARCHAR(10) )

SELECT * FROM tempdb.sys.Columns WHERE Object_ID = OBJECT_ID('tempdb..#tmp1')

IF OBJECT_ID('tempdb..#tmp1') > 0

DROP TABLE #tmp1

As per my understanding what you have to do is create an Update trigger on your table, where you have build a logic to update col1

if Col2 is updated then...

SELECT A.ID,

CASE

WHEN a.StartTime != b.StartTime THEN 'Start Time doesn't match'

WHEN a.EndTime != b.EndTime THEN 'End Time doesn't match'

ELSE 'Record Not found in TableB'

END

FROM

TableA a INNER JOIN TableB...

You can check the example on below link...

http://sqlity.blogspot.com/2008/03/partition-table-example.html

I guess TRY CATCH block improves the error handling in store procedure, it doesn't have any performance issues with it.

You can check the log file for getting the process details. As per my knwledge it is store somewhere in C:\Program Files\Microsoft SQL Server\80 or 90\bin....

refer this ...

http://sqlity.blogspot.com/2008/07/script-to-return-rows-count-from-table.html

This will return all tables Rows informantion...

SELECT OBJECT_NAME(object_id), Rows FROM sys.partitions WHERE index_id = 1