We test them daily as they are transferred and restored to another server.

This another server is called "the clone".

Therefore anyone (testers, developers, ...) can do tests, simulation, analysis,... on the...

I didn't mean that.

When we store the data in the DB, we convert ' to ´ in the C# code.

We almost never store any litteral in SP, Triggers,...

So when the...

For easier maintenance & management, we replace ' with ´ when we store names in the DB.

Ex:

DECLARE @name varchar(100)

SET @name='GIRI''S'

SELECT @name,replace(@name,'''','´')

Therefore, we don't need to encode them when we fetch...

I didn't even got the 8 points !

Guess I'm too young to think that Elton as something to do with rock...

I did the same recently. The biggest issues for us was the *= joins.

I used this script to look for any *= in storedproc. All our sp are...

Not quite sure about this but I think that debugging is not feasible on a SQL2000.

When we have to do some debugging on sql2k, we use the "PRINT ..." statement.

Ex...