Apologies to all, this was not a problem after all but 2 rogue rows in the data! I'd been looking at the data that long, that I'd confinced myslef...

Hi David, I wasn't using Excel just SSMS.

Fixed it!!!!

I removed the HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\100 and re-started SSMS. It got a little further before crashing. I then remembered that I had APEX SQL Refractor installed on...

Tried a local user rather than domain user and at least it got passed the splashscreen but did crash on exit with anothe .NET Runtime 2 error. So it...

According to the log:

Product: SQL Server 2008 R2 Management Studio -- Installation completed successfully.

Doh, forgot the important details 🙂

It's on Windows XP SP3.

Here's a link to a function that splits on any string up to 4 characters in length.

Hi,

Does the Assembly and stored procs have to be installed in each database, you wish to call the stored proc from? The example works fine, when:

SET @sqlcmd ='Select *...