Apologies if you feel this goes way beyond a free forum request but you have under miss-understood my request.

I am not after someone to providing me with...

Good idea. I'll need to check though as most extended SP's are locked down in these environments.

Thanks guys, Sorry for the delay in replying but the country I live in has suffered a few 'shakes' recently and as a consequence I've had an intermittent internet conn....

Thanks guys, too simple 🙂 I've moved into a more management role and sadly not kept my basic skills up to date.

Please ignore I worked it out in the end.... All I needed to do was perform an insert into a temp table. Simple!

INSERT @AvailMbytes EXEC (@Script) AT SQL_11

If anyone interested...

Firstly, thanks for the response. 🙂

I get that, but I thought that by default MSDTC service is running locally, even with Failover Clustering installed and therefore you didn't...

Thanks for the quick response.

Its currently has 5 instances, 1 of which is Analysis services. It also (don't know why as its 2008 cluster) has MSDTC as a resource.

Thanks guys.

This is for a 'sunset' application/db that is being replaced by a slow migration of functionality rather than a big bang. As a consequence we cant change the front...

Thanks.

I think what I may have to do is extended the original tables field.

Thanks so much. Its embarrassing, thats so simple. I couldn't see the wood for the trees :blush:

Thanks, I'll test it out. We had an incident the other day, and I thought it might be best to keep a script on hand just in case someone else...

Doh! Thanks that was too simple 🙂

Cheers, Phil

Thanks, but I still get the same results. Is the syntax correct:

DECLARE @retval XML

DECLARE @sSQL nvarchar(500);

DECLARE @tablename nvarchar(50)

DECLARE @ApplNbr VARCHAR(20)

SET @ApplNbr =...

Happy to.

The TRY_CAST returns a value cast to the specified data type if the cast succeeds, if not it returns null. Which solves my problem by immediately telling me which...