Very Computer

Hi,
    I'm testing the Upgrade path from 6.5 to 2000. I have tested the upsize
Wizard and am having problems with UDF's after the upgrade. When I try and create
a UDF I get incorrect systax error near the word Function. I though at first this
may be a security issue, but trying to Grant Create Function produces the same
error. It looks like 'Function' is not recognised as a keyword by the upgraded
database.

Any ideas as to why this is happening ?

I have tested using DTS, this works fine and I can work with my UDF's. Any
shortfalls in just using DTS rather than the upgrade Wizard ?

Cheers
Gary

It's been a while since I did a 6.5 upgrade, but I believe the upgrade
wizard leaves the database in "6.5 compatibility mode".  That disables a lot
of the new functionality for strict backward compatibility.  This can be
examined and changed with sp_dbcmptlevel stored procedure and nust be
executed for each upgraded database to take advantage of new features.

Strictly speaking, new features are not disabled by the compatibility modes,
but new keywords are; that is the problem you are running into.

Hi,
    I'm testing the Upgrade path from 6.5 to 2000. I have tested the upsize
Wizard and am having problems with UDF's after the upgrade. When I try and
create
a UDF I get incorrect systax error near the word Function. I though at first
this
may be a security issue, but trying to Grant Create Function produces the
same
error. It looks like 'Function' is not recognised as a keyword by the
upgraded
database.

Any ideas as to why this is happening ?

I have tested using DTS, this works fine and I can work with my UDF's. Any
shortfalls in just using DTS rather than the upgrade Wizard ?

Cheers
Gary

Thanks Lewis,

yep, that makes perfect sense.    

I'll upgrade again and check the compatibility mode, might have been nice if MS had documented this clearly in the
upgrade white paper. (If it's there I can't find it).

thanks again for your help on this one

Gary

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!