Thanks for all your advice and comments on MySQL. I've never looked at it before and i am still a little scpetical about jumping ship from SQL Server 2005, but...

Point is that those precious DBA's are going to have to shift to the real world sometime soon..

I'm a DBA and a Developer... Accent on Developer.. 34 years experience ss...

My opinion, for the most part, for them being there is the same as DTS and Cursors... they were created to make it easier for folks that don't really know...

Although i've not found many real cases to implement CLR one that i thought about the other day was that accessing data in a CLR vb.NET sp would be quicker...

I can't really give an imformed opinion about Oracle, but i did notice a comment about how you could use SQL Server out of the box. I can understand not...

I totally agree with you, there are other sites for that kind of thing. I only mention it as a database programmer who uses SQL server 2000, building systems using...

Thanks for your help. It was a typo on my part in the message. The problem I had was that the Server and Package name were not enclosed in quotes....

Thanks for all your suggestions.

I am trying sismith's suggestion however when I try to run it I get an error message saying it can't find the server or that access...

Many thanks, that works a treat!!!

Thanks a lot. I tried your code and it worked after removing the CAST function from the code (it didn't seem to be needed). I'm fairly new to this so...