Thanks Jason,

This could be good solution, I will work on this.

Thanks for your solution.

This is working fine when the source connection is SQL Server or Oracle.

When I change the datasource to Teradata it is throwing this error.

Yes correct

I have changed the datatype of the variable to Int64, still it is giving same error message

The actual count is 38044708, ans Int data type can handle this count.

declare @i...

Datatype is Int

I am assigning value of below query to the variable

select count(1) from Mytable

I am using temp table instead of cursor.

declare @spname varchar(100), @sptext varchar(max), @cnt int, @i int

select @spname = '', @sptext = '', @cnt = 0, @i = 1;

create table #spnames(id...

Which version of SQL Server you are using?

I thought it will conevert everything to int. As the expression eveluates from right to left so from the right first plus will return 121 (120 will be converted to...

Good question, my bad is I just ignored 1 so I checked only -1 and 25 I missed out 1 🙂

you can also check the below article from Pinal Dave

http://blog.sqlauthority.com/2009/05/03/sql-server-add-or-remove-identity-property-on-column/

Thank you very much, it is very clear now.

Did you heared that in T-SQL for Sql Server 2005.

As of now I know only Procedural Language in T-SQL.

Dividing the complex logic into small small parts and keep that in...

what is the version of SQL Server you are using?

Where is the question? or the topic itself is question?

The problem with Replcation is while replicating data from one server to another, if anything goes wrong or any other disaster like power failure or hardware failure happend then again...