Does not use / require any kind of authentication, example if...

It would have been better had you used Google and...

Good Question Jack .

Good to hear that, thanks for updating here.

Is the SQL Server accepting connections actively when you have this issue?

You need to setup Linked Server and use 4 part Notation, ex: LinkedServer.Database.Schema.Table in your queries.

Search Google for Linked Server in SQL Server and you will find plenty of...

I second Lynn's reply. Read the referred article and post all what you have tried, that gives a head start for some who wants to solve.

Help us to help you....

Firstly, wrong place to post, the topic Try Catch block is not available in SQL Server 2000.

I have not heard/read anything such as TRY SUCCESS in SQL Server.

BEGIN TRY...

My suggestion would be going with SSIS Packages.

Right click on the SQL Server Agent and choose properties. Choose the option as shown in the attachment. (See the attachment.)

Does that help?

The thread is taking a breather after the 10000 marathon.

Common Barry where are you? :ermm:

Just saw that from Post# 9989 to 10008 (20 replies) you posted 14 replies... :w00t:...

Absolutely right !

From AP, India.

Currently in PA, USA

I am with Lynn on this, read Books Online and search Google with the phrases you post here, you must be finding plenty of blogs, articles and such forum discussion...

Yes it is possible. Use the Code below

DECLARE @xml NVARCHAR(MAX), @body NVARCHAR(MAX) , @SUBJ...