Can't create a function

Question

Can't create a function

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

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

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Bruce W Cassidy SSChampion Points: 12668 More actions · Answer 2

[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]

JBANKO SSC-Addicted Points: 453 More actions · Answer 3

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