I don't need to. He is a noted trombone player and you can visit his web site for yourself!

I agree with the assessment on the breadth of his knowledge...

If ever you need a trombone player with a shark fetish Frank is your man!

I don't know about a specific bolt-on for SQL Server but our translation department tell me that there are automated translation dictionaries that do the bulk of the work.

The bulk...

I've seen an ORACLE database slaughtered by a web content management system in testing, but in real life it coped just fine.

One issue I have seen with testing is coming...

You say that the locking issue only applies at the default isolation level of READ COMMITTED

Surely this knocks the ORACLE guys argument for six because although it is the default...

I went to a SQL2005 tech-ed briefing and was told that ultimately SQL2000 was limited however no expense has been spared on SQL2005 to ensure that it does scale.

With SQL2000...

This question is a lobbed hand grenade. I hope the SQLServerCentral.com servers are up to the flaming.

Replace any single quote instances with two single quotes in your variables.

I should also use a stored procedure and use what ever the .NET equivalent of a Command object is...

SP4

@set PATH=%FrameworkSDKDir%\bin;%FrameworkDir%\%FrameworkVersion%;%PATH%;

Shouldn't that read

@set PATH=%FrameworkDir%\bin;%FrameworkDir%\%FrameworkVersion%;%PATH%;

And in the source code where is the LogIt function defined?

Other than that it is nice to see a practical example of the CLR functionality.

I totally agree, and as the summer holidays are coming up I'll be removing the blocking of "Valium" from my SPAM filter

During the industrial revolution one of the mill owners discovered that when he cut his workers hours from 18 per day then productivity shot up!

Sir John Harvey Jones was famous...

Also, don't forget to click on the refresh icon.

Providing that the login that is used top register the database has the correct permissions this will work.

Double-check which database you created...

Thanks for this.

I've resorted to having a windows CMD file run with

NET STOP SQLSERVERAGENT

NET START SQLSERVERAGENT at 06:00 every morning.

It is crude and horrible I know but 9...

In your 2nd attempt your where scandate'1899-12-30 00:00:00.000' needs to be outside of you derived table query.

Loose the DISTINCT from the derived table query, it is superfluous.

Do you have and...