As Gail already mentioned - did you look at SQL Audit? You can audit actions (insert/update/delete/select) for specified tables (by specified logins) and have this information logged into a file...

You could also try the following:

a) Identify the tables that are out of synch using the xact_seqno and sp_browsereplcmds

b) Use the tablediff utility http://msdn.microsoft.com/en-us/library/ms162843(v=SQL.90).aspx to compare the data in...

If your subscription expires aren't you trying to re-initialize the subscription? i.e. drop the subscription and then re-create and initialize the subscription - which will take care of getting all...

There was a (sort of similar) discussion over at http://www.sqlservercentral.com/Forums/Topic528119-146-1.aspx

This link has information on how to use synonyms to enable connection to the snapshot objects - allowing the snapshots to...

The DMV sys.dm_exec_query_optimizer_info is supposed to have this information - I remember reading some...

If you right click on the SELECT operator on the plan and choose "Properties" there's a "Reason for Early Termination of Statement Optimization" that has the value "Time Out". I...

From http://technet.microsoft.com/en-us/library/ms188603(SQL.90).aspx:

In certain cases, a parallel plan may be chosen even though the query's cost plan is less than the current cost threshold for parallelism value. This can happen because...

This was the article (I need to organize my favourites better ;-)):

http://blogs.msdn.com/b/sqlcat/archive/2008/08/05/microsoft-sql-server-database-snapshots-and-synonyms.aspx

Well - happy to know I guessed right... 😀

<Guess>

Looking at the exec plan - the Sort is taking 73% and this seems related to the following:

,ROW_NUMBER() OVER(ORDER BY p.PortfolioCode) AS POSN_KY_POS_ID

Is there any difference if this is removed...

In your new SQL 2008 environment - did you try changing the default schema of your user login and see if that helps?

Something like this:

ALTER USER balaji WITH DEFAULT_SCHEMA=balaji

Replication works fine for tables that are in schemas other than dbo

How are you adding the articles for replication - i.e. are you doing it from the UI or are...

One approach we used in of our projects was to use synonyms.

We mirrored our OLTP DB and created a snapshot of this mirror which was then used for reporting....

Googled this out of curiosity and found the most disturbing explanation for index segmentation...

http://www.careerride.com/sql-server-what-is-index-segmentation.aspx

:ermm: :alien: :w00t: - looks like a "WTF!!??!!" icon is needed

From http://msdn.microsoft.com/en-us/library/ms187928(v=SQL.100).aspx 130 and 131 are styles to convert Hijri...

more information here: http://think-sql.blogspot.com/2009/09/working-with-hijri-date-in-sql-server.html