@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...

Brilliant!!

The downsides to telecommuting are that you become the invisible employee (See Steve's editorial 21st June 2005) and there is less emotional baggage in firing/downsizing an invisible employee.

There is definitely...

There is a government network that has so many levels of security that the must-have device for any lap-top user is a dial-up modem because the speed of a...

Bio-diversity is why we haven't been wiped out by

a) The black death

b) Smallpox

c) Flu

d) Umpteen others

I agree with pg53. The key is that the people managing these diverse technological...

Now if only that worked on girlfriends.

The problem with COMMIT TRANS in this case is that it results in a wife and massive consumption of resources.

ROLLBACK TRANS and your handling...

Been there, done that.

To be honest, when I have a single record update I open up the table in Enterprise Manager and edit the record manually. You can't accidentally...

It doesn't do any harm to code SELECT 1 FROM etc

Playing devils advocate I would say that

a) It emphasises that this SELECT statement is for a specific purpose

b) SELECT *...

Apparently not because EXISTS short-circuits

Is that a dagger I see before me?

If you put a clustered index on something it is best done on a field that is naturally ordered such as a sequential id field.