SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY not working with Linked Server or Remote server ???

Hello Friends,

I have faced a problem using SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY with Linked server

Let me explain with example...

Please see this URL

http://the-it-articles.blogspot.com/2010/12/partner-transaction-manager-has.html

I agree with Steve Jones - Editor (Post #987787)

Dear Friends,

Yes i have checked your way also we can do update with this way...

temp table is temporary table after we should remove this.

Thanks!!!

found the solutions...

actually if the tables lie in different dbs

then create temp table in db X that contain the data of tableB from db Y

this way our both...

Dear Friends,

if tableA from database X and TableB form database Y then how can handle this situations

Please reply anyone !!!

Dear Friends,

i agree with you to use tsql solution. there is no problem to use ...

FYI : solution that i provided above is also free and it works free...

Dear Friends,

if you are hesitating working in production

Please follow below steps ....

if your database is empty and you want to create fresh db

1.) Create a db in your...

Dear Friends,

This is freeware and very easy to use ....

Please try this ...

http://www.red-gate.com/products/SQL_Search/index.htm?utm_source=cp&utm_medium=email&utm_term=3534&utm_content=search_launch&utm_campaign=sqlsearch

Yes try SQL Server Books Online. this is good books

Dear Friends,

I have few question with you

Are you try to access thru network ?

Did you setup the SQL Server Client Network Utility ?

Did you try as above suggested ?

Dear Friend,

Please specify your problem....

if you question is only

Gmail SMTP SERVER NAME is what?

Answer is : smtp.gmail.com

Dear Friend,

Once we install SQL Server it ask Instance Name ....

if you use default name ....that mean your SQL server Name = Your Machine Name

if use any specific name...

Dear Friend,

Please refer the below URL ...

http://blog.sqlauthority.com/2008/06/12/sql-server-2008-step-by-step-installation-guide-with-images/

Varinder Sandhu

http://varindersandhus.blogspot.com/

Dear Friend,

please check prerequisite SQL Server 2008 on your system ...

please refer the belwo URL

http://msdn.microsoft.com/en-us/library/ms143506.aspx

Varinder Sandhu

http://varindersandhus.blogspot.com/