basically SQL Server creates a job to run log reader as and when agent starts.  If that is created properly you are fine.  (Delays are possible when the publisher, distributer...

This workaround may help you.

After the snapshot replications ( both tables )are created (let me say them are created as DB1_TableX and DB2_TableX) , stop the agent for a while.

Copy the...

Weird!  Ident_Current('TableX') should be null if you are running the query from SQL1. (I assume you don’t have the same table in SQL1)

However, If it is working..Dont break...

This is one of the areas where you may need to query system tables. The following query returns all tables and their identity values. (I assume that the identiy columns are...

My apologies...  Just a few minutes back I found another area where we need to access system tables:  to identify current identity values on linked server. you article is usefull in that...

I mentioned 3 points... Unfortunately all negative points:

1.  The crisis is nothing to do with Identity.  It is regarding DB design. I believe all agree on that. 

2. This is...

All data types have their limits. This crisis is nothing specific to Identity columns.  It is related to lack of upfront planning.

Additionally, Microsoft always recommends us to use Information_Schema views and...

Hi,

Thank you for oyur reply. 

The existing publication contains some vary large tables,  (millions of records) so if I drop and re-create the subscription, will I have a new snapshot...

The second index appears like a  "covering index".  it will be usefull to read the data directly from index without going to the data pages. 

Another thing i can see...

Let me share some of my thoughts on this.

First of all I would like to admit that I am a bit clueless on this issue.

thank you very much for your valuable comments. I am sorry, I should have elobrated it in the first place itself.  However, if you have any issues, please feel free...

yes.

before running your statements, run this statement:SET DateFormat dmy

remember; this statement is connection wide.

Fron what i gathered, you can create proc using any language.

check http://www.codeproject.com/Purgatory/NET.asp for further details

better design would be you seperate them into 2 fields and connect seperately

However, this would do:

Select A.*, B.client_ID  from BDI A, Client B where substring(A.clientref,1,6) = B.clientref and...