Can''t create User Defined functions!

Question

Post reply

Can''t create User Defined functions!

Viewing 7 posts - 16 through 21 (of 21 total)

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

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 1

can u do this.

right click the server and click properties

please mention these details

Product

Product Version

My Blog: http://dineshasanka.spaces.live.com/

jcfilth SSC-Addicted Points: 447 More actions · Answer 2

Product: SQL Server Standard Edition

Product Version: 8.00.878 (SP3)

Vladan SSC-Insane Points: 22072 More actions · Answer 3

Hmmm... I really don't know... let's try to look around. What is the database you are using? Is it user or system database?

Can you run these statements and post results here:

select suser_sname()

select user_name()

jcfilth SSC-Addicted Points: 447 More actions · Answer 4

It is a user database.

select suser_sname(): sa

select user_name(): dbo

SURPRISE!

I've created a new database in the same server and there I have no problems!. I can create the UDF's. I only have problems in my production database! Any new idea?

jcfilth SSC-Addicted Points: 447 More actions · Answer 5

YEEESS! I've found the solution for my problem.

The problem was the level of compatibility of the database. It was set to Level 65 (because this database was started in SQL 6.5). I've changed it to Level 80 and now it works (I don't need the backward compatibility)

Thanks to everybody who tried to help me!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 6

Doh! I can't believe I didn't think to check that. Would this be worth making a FAQ (I know it's not frequent, but the compatibility level often causes similar problems)?

Vladan SSC-Insane Points: 22072 More actions · Answer 7

LOL... who has that wonderful icon, banging the head on a desk? Phillcart? Well, that's how I felt when I read the explanation. In fact this was the simplest solution - and nobody remembered to ask about it.