And this is the code that works in 2000 :

SELECT RAND(CAST(NEWID() AS VARBINARY)) * 10000000000000 AS Test FROM master.dbo.SysColumns

Why do you think he used THIS CODE???

RND(CAST(NEWID() AS VARBINARY)) * 10000000000000

Did you actually run the statement before saying that??  The data will be unique for each row.

Why even use a cursor for this, you can reinitialize the the rand() for each row and do a single update which would most likely take only a few seconds...

SELECT RIGHT(REPLICATE(`0`, 11) + CONVERT(VARCHAR(11), YourNumberColumn), 11) AS FormattedColumn FROM dbo.YourTable WHERE ...

I was reffering to the create / disable version.  If you're going to write that logic, you might as well DROP IT.  That way there can't be any confusion later...

I just have one question.

Do you disable tables and columns you don't use in an application or do you drop them, or even better, don't install them at all in...

Crate temp table that matches the output of sp_spaceused

insert into #temp (col, list) exec sp_spaceused ...

Not the prettiest thing I have ever seen, but how about creating the trigger, then checking if you have to keep it depending on the client and dropping it again...

Who owns the jobs that start the packages?

Check to see if there's a difference in the context (different user) between each runs.  That would be my first guess.

You might as well finish to post your homework or exam, you'll get the answers faster that way!

I didn't answer because it most likely was a homeowrk question... but I guess we will never know know .

Check out the Microsoft site for more info, I don't have a link available (maybe someone else will).

The simple fact is that if it worked with 2000, it'll work with...

Check out the functions UPPER, LOWER, LEFT, RIGHT, and Substring to solve this problem.

You lose the chance to use the new 2005 features.  That's about it.

I'm sure there are a few more gotchas than this, but I would not expect a lot (this...