Geek Answers Handbook

Is it possible to call a function in SQL Server 2005 without [dbo]?

I have a third-party program that insists on overwriting some SQL statements using UCase(value) . UCase not supported by SQL Server 2005, so I decided to create a User-Defined-Function function that returns UPPER(value) and assigns it a UCase alias, however, it looks like I still need to use [dbo].[Alias]

Is it possible to call a user-defined function without the [dbo] prefix? Or is there a way to force SQL to run SELECT UCase('abc') as SELECT UPPER('abc') ?

+4
source share
1 answer

Unfortunately, no, it is not possible to invoke UDF in SQL Server without first specifying its owner. Here you can find several discussions on this topic:

http://www.google.com/search?sourceid=chrome&ie=UTF-8&q=call+sql+server+function+without+dbo+prefix

The solution, of course, should force a third-party user to fix the application. Is this not an option?

+1
source

More articles:


All Articles