Silly question.  You have validated the dll exists on your SQL server and that it is registered?

IF you already have the clustered index WorkOrder, TransactionDate DO NOT add a NON-CLUSTER index to do the same thing.  This is redundant and could cause perf. issues

An alternative to Frank's wisdom (as always) is to create the SP in a common user database and just have EXEC DATABASE.OWNER.PROC statements elsewhere.

Of course Frank's way takes care of...

I'm sure you can.  The code sample I provided is just 1 way of attempting to ID if the year is a leap year or not.  The meat of the...

I am sure that it is but the first question is WHY do you want to mess with one of the MOST IMPORTANT tables in your database like this????

SELECT CAST(MONTH(GETDATE()) AS VARCHAR(2)) + CAST(YEAR(GETDATE()) AS CHAR(4))

IF ISDATE(CAST(DATEPART(YEAR, GETDATE()) AS CHAR(4)) + '-02-29') = 1

  BEGIN

    PRINT 'Leap year'

  END

ELSE

  BEGIN

    PRINT 'Not a leap year'

  END

You can also research this in BOL under Index tab:

Editions of SQL Server and then select Maximum Capacity Specifications under topics found

The only way I know of is to create a VIEW with the name that you want to be used

Give them access to views that are read-only for the reporting application OR force them to use stored-procedures to return data for reporting.

I think that other development programs/system REQUIRE this however, MS SQL doesn't.  Depending on what shop you are in it may be a part of the company policy but SQL...

Dont forget to turn that OFF.  Very bad to modify system and forget that step

Add a column, insert the data and then remove the original column.  Question is though WHAT importance are seconds/milliseconds AND WHY do you need to convert this to VARCHAR instead...

We have seen the NaN error with Crystal as well.  I think it was due to NULL being passed into a numeric field or that the field width was too...

For error trap I use

IF @@ERROR <> 0

  BEGIN

  END