I just found that SQL Management studio is adding a server in Linkedserver folder though the connection is not established properly. Now, Im up to running script to create a...

Your reply solved my 3 hours head ache. I never looked at that bit of code ...

Thank you

After your reply , I have googled and read about OUTPUT Clause and it will perfectly improve the performance.

Thank you.

Updatede cursor (posted with clear explanation )

declare @pidentity int

set @pidentity = 0

DECLARE cur cursor for

select id from x ...

Sorry forgot to mention about table x. Table x is copy of records from other table (old database) that satisfy certain condition. old table contains some test data and irrelvant...

I have used delimeter ',' and also had some text containing ',' in one of the data field which was causing the problem. But I still wondering how to populate...

Thank you everyone.

I certainely thought about creating linked server but I wasnt sure. I will try both the options mentioned in the post. Thanks to everyone who has replied to this post.

Ta

I have tried using Ip address but im not sure how to use them in query? Is it possible to give an example to write a basic query using...

sorry, Im not able to see any information on the link you provided. Can you give specify the correct link

Ta

I clearly understood that I first plan what needs to recovered in case of disaster then try to figure out DR method that suits my business process and implement at...

Does this mean I need to create replication before starting the development?

Ta

Thank you very much guys.

Thank you. Your explanation cleared my confusion.

Here are my table scripts.

CREATE TABLE Product

(

product_id varchar(20), --- Primary key

product_name varchar(30)

Constraint PK_product_id Primary Key

) ON Primary

Create TABLE Sku

(

sku_id varchar(20),

...