schema

27 Jan 2006 8:28 AM

Alan

Hello,

I am making a database migration from Sybase SQL Anywhere to SQL server 2005.
Under sybase I had functions I use in VB6 applications, and in VB6 I call
these functions directly by their names
ie: select fGetText(1)
but with SQL server I have to specify the schema before the function name
ie: select dbo.fGetText(1)
I tried to create the function without specify the schema, but by default it
uses dbo.
Is there a possibily ?
With the tables, I don't need to specify the schema...

Thanks

27 Jan 2006 8:41 AM

Tibor Karaszi

You *must* schema qualify scalar user defined functions, no way around that. Actually, it is a good
idea to schema qualify all object references.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Alan" <A***@discussions.microsoft.com> wrote in message
news:FB1620E4-F40D-44C7-8335-4528F1560878@microsoft.com...
> Hello,
>
> I am making a database migration from Sybase SQL Anywhere to SQL server 2005.
> Under sybase I had functions I use in VB6 applications, and in VB6 I call
> these functions directly by their names
> ie: select fGetText(1)
> but with SQL server I have to specify the schema before the function name
> ie: select dbo.fGetText(1)
> I tried to create the function without specify the schema, but by default it
> uses dbo.
> Is there a possibily ?
> With the tables, I don't need to specify the schema...
>
> Thanks
>