Thanks, I might have to do that.

Quick question! Call me cynical, but how does everyone back up there SQL Databases in case of physical damage to the server?

Hi Kashif,

Cheers for pointing out the typo. I've changed the pubs database to Northwind, with no success. I intend trying to connect through VB as recommneded by Prakash,...

Hi Prakesh,

I'm heading out the office now, but will try your recommendations tomorrow.

Thanks,

Alan

..I have changed the initial catalog to Northwind, with no success. I am not receiving any error notification.

Any further recommendations would be appreciated.

Cheers,

Alan

Edited by -...

Hi Frank,

Haven't seen that code before - thought it was merely a matter of creating a connection object and then opening it.

Don't have any error handling routines switched...

...unfortunately not the browser merely hangs for a few seconds and then returns a blank page.

Hi David and Frank,

...I hope my query isn't giving either of you any keyboard cramp! David, thanks for the code, which is a great improvement on what I had....

a boer maak a plan!

loosely translated = a farmer will make a plan!

Thanks Crispin, the Query I was looking for is:

Select * from (tablename) for XML Auto, Elements

Cheers

True, but should the objectives of a sporting code be to be played by and appeal to all nations. It is great for athletics and such, however for certain sports...

..you guys have digressed from my query, but it looks like FOR XML should do the trick.

..I know this is subjective, but I reckon passing the ball forward during sport...

..will do, nice to know things are still operational in Johies after the nail biter against Scotland on the w/e