Well, a bit more information. I have found a server with SQL Server 2000, windows 2000 and MSDTC 3.00.00.3535. I have tried running a package enlisting DTC on...

I've managed to resolve this, it seemed to be down to a lack of indexes on one of the queries

Thanks guys, I've gone down the OLE DB route as the alternative, just wanted to make sure I wasn't going mad:)

Passing a table to a stored procedure is an interesting idea.  I may have missed something, but doesn't this have an effect on the compiled execution plan for the stored procedure.

After successfully using my SQLXML import now, I have now noted that on the SQLXMLBulkUpload class there are the extraordinarily useful properties

Schemagen and

SGDroptables

This looks handy I thought to myself and...

Hi Bledu,

Many thanks for that,  I was originally looking at the openXML option,  but I've gone down the XML Bulkload option

I've create two tables called tbl_impcustomer and tbl_impcustomeraddress in...

Hi, I have managed to test the code using a few constraint violations successfully.

Of course one should always ensure that objects exist, but since I knew the view didn't exist...

Hi Sugesh,

I have tried using SET XACT_ABORT ON both in the first line of the SP and before the executing the SP with no luck.

Yes the views will defnitely be...

Hi Greg,

Yes the logins are my main concern, scripting out the logins would mean a new password for all of the database users. Of course this wouldn't be an...

This may sound a little obvious but does the SQL Server account have full rights to the directory that the MSAccess database is on ?

Hi Swede,

I've had this, It could be that the user that you login to SQL Server to run the linked server query with doesn't have sufficient rights.

Checkout http://support.microsoft.com/kb/814398

As...

Hi Yes,

Standard is installed on the new server. The old server has since been decommissioned, but when select the version number and edition SQL Server tells me that I...

Thanks - good call, I'll keep an eye on that

Regards

Simon

Hi Peter,

Thanks for the reply, I've been checking the duration and have noticed some relatively high figure in the region of 20 to 30 seconds, but also wanted to try...

>>SELECT * FROM ::fn_trace_getinfo(DEFAULT) <<

Cheers Ram

that's exactly what I'm after