A few more questions for you to make sure I have this...

So your database can be of type "c" OR type "t"

Version can be 000, 001, 002, etc. this...

Post what you have now and highlight the areas that you want to change. I'll take a look at it later if you don't have a response from someone...

Ah, OK, this is about what I suspected.

The % is used as a wildcard within a SQL statement using LIKE. That is NOT what you are doing at all.

Within...

Take a look at the DATEPART function. That's probably your best bet.

Oh wait a minute I see it now...

In your function:

IF @v_curValue = 0

...

c% is not an int so it makes sense that it would error out.

c% is a string and that's the data in the table. So if you want something...

Add the highlighted line - what is it returning?

DECLARE @iSchemaVersion NVARCHAR(10)

SELECT @iSchemaVersion = dbo.determine_current_schema_version()

[highlight=#ffff11]SELECT '*'+@iSchemaVersion+'*' as CheckiSchemaVersion[/highlight]

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

--*****************************************************VERSION 001**************************************

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

IF @iSchemaVersion < 't001'

Using < with a character string is a tricky thing. What exactly do you want when you have:

IF @iSchemaVersion < 't001'

do you really mean "do this if the schema...

You're returning an INT, so it's a scalar function.

Would some MSDN whitepapers help?

http://msdn.microsoft.com/en-us/library/cc966545.aspx#EGAA

http://msdn.microsoft.com/en-us/library/ms190768%28v=SQL.90%29

Should work by just removing the 'GO's after the create function part.

Speaking of, why are you doing this:

IF @v_curValue = '0'

...

Have you tried running Profiler to capture all SQL activity during the update?

What I'm worried about is log entries which indicate that Agent XPs are disabled when they're not (during a production job run):

2011-02-07 02:13:00.98 spid55 SQL...

I did find some information in the default trace, but it's not making much sense. Someone did sent a stop request. Who I don't know. The SPID...

Of course, setting a fixed size with no autogrowth has its own inherent risks.