Hello,

The below is the code.I am getting the above error while executing this.

Just What i want is if the error comes then it will go to the next server and...

I Will practice with those and let u know....Thanks allot.....

Thank You....

Can u provide any example  by using openrowset?

which one gives the better performence?

Thanks,

After connecting to the remote server have to executive some queries in the remote server.

For that i have created some dynamic queries and executing those thru the linked server.

Is there...

Ok.Thanks allot for your information.I have searched and found in event log...Thank You.

Bagath.

Ya you are right i want exactly that only....

Finally i have got the query from our team only....

Thanks for ur valuable suggestion...

Rao Aregaddan.

Simply superb    🙂

Thanks allot for ur help........This query is working for my criteria.....Thanks once again...

Rao Aregaddan.

Ya i have posted one query with the subject "needs a single query for selecting dates..." today itself only.

That is only my req.I have wrote one query like this but...

ex:-1

date    

------

08-29-2006

08-25-2006

07-14-2006

06-13-2005

For the above we have records between getdate()-5 and getdate()

so the output must be max(between getdate()-5 and getdate()) i.e   08-29-2006

ex:-2

date:

------

01-26-2006

12-07-2005

04-04-2004

11-08-2007

For the above there are no records between getdate()-5 and...

Ok...Thanks for ur information.....

I will use another temp table to get the data....

Thanks to all............

Rao Aregaddan.

I dont want to use GO and know that all variables expire after that....i have given that code for ex only....

In my proc first one temp table will be create,have...

But how to get the criteria with in that procedure....?

is there any other way...to do like that?

Thanks,

Just check out the below.I have developed like that only.Suggest me the better way than this if any.

ALTER PROCEDURE SP_LOOP_CONNETREMOTE

AS

DECLARE @IP VARCHAR(24)

DECLARE @Password VARCHAR(24)

DECLARE @DBName VARCHAR(24)

DECLARE @Stmt VARCHAR(200)

BEGIN

DECLARE Cursor_Connect CURSOR...

Can u explain in detail..?

Concept:

---------------

Have to connect to more than 1000 servers....

Using test server we have to execute in remote ( remote tables are not available in this server)

First have to connect...

Thanks to all of u for your valuable suggestions...........:-)

Thanks allot......

Rao Aregaddan.