Hi Steve

Now, I am not writing...

Hi e4chats

I found a solution to the problem.

You have to download & install SP1 of the FULL version of SQL Server (not the EXPRESS version).

Apparently SP1 of the full...

Hi folks

Many thanks for your feedback - appreciate it.

Ross

Hi Steve

Yeah, I agree. It is not that hard to be civil to each other.

As a newbie, I fairly often scratch my head at some of the replies, but...

Perhaps you could open the XML in Excel, then save the Excel workbook as CSV then do a BULK INSERT.

Kind regards

Ross

Hi dcorbitt 🙂

Thanks for your help - have been very busy with an extension on our home, so have been unable to reply till now.

I had a look at the...

Hi folks

Problem solved

Ross

Hi Steve

Well, in general I tend to agree with your thoughts regarding the pace of information. It is something that is forcing me to cull the number of organisations...

Hi folks

Well, I live in Australia, and like the UK we drive on the left hand side.

In respect to the comment that Steve made about the steering wheel being on...

I agree with the above 2 suggestions - using error handling is a good idea.

In terms of performance, it is a good idea not to name a SP with the...

Hi Shaun & David

Assuming that it is not essential to use a Dataadapter, I think Shauns suggestion is a good one!

Just a comment, in respect to the SP spDoSomething -...

Thanks Mathew

By DDL do you mean the database diagram?

If so, I will post it shortly.

Kind regards

Ross

HI folks

This is just a general comment about using SQL Mail.

I have read a few articles that have suggested that there are fairly significant security risks with using SQL Mail...