January 29, 2009 at 7:35 am
when the old SQL 7 was upgraded, non-system databases were left at compatibility 70.
since you clearly have a need to use functions, I'd change their compatibility to 80 and be done with it;
personally, i can't remember anything that actually breaks due to old developer code depending on 70 ONLY features....but if someone reports an error, you'd just change the db in quesiton back to 70 and go back to business as usual.
Lowell
February 1, 2009 at 1:58 pm
[font="Verdana"]I was going to suggest you check the version of the database on which you are trying to create the function. I'm glad someone beat me to it. 😀
User defined functions were introduced in SQL Server 2000, so any older databases won't accept it. You can easily upgrade the database version through Enterprise Mangler though. Please test the upgrade with any applications that make use of the database before you upgrade the database in production: a version upgrade can break stuff.[/font]
February 2, 2009 at 6:37 am
I certainly do appreciate everybody's responses. And there were no issues with the DB changing modes that showed up yet. Considering this is a well used database I guess that's good news. Now all I need to do is find a question or 2 I have an answer for on this forum.
Thanks again to everyone.
,
jb
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply