Newly Created Function Is Not Available? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Newly Created Function Is Not Available?

Author

Topic

Sheeraz
Starting Member

4 Posts

Posted - 2010-08-16 : 05:06:50

I am working on a scalar value function in MSSQL 2008. I created it and It is shown in object Explorer But when I use this function in MS Query Analyzer It gave me error

**Msg 208, Level 16, State 3, Line 1

Invalid object name 'calculatecptcodeprice'.**

For Me this type of error after creating Function is new. What went wrong. Please Help, I restarted the SQL Services, but no use.

Thanks In Advance

Sheeraz

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2010-08-16 : 05:10:46

Scalar functions need schema naming.

SELECT dbo.YourFunctionNameHere(1)

N 56°04'39.26"
E 12°55'05.63"

Sheeraz
Starting Member

4 Posts

Posted - 2010-08-16 : 06:11:56

Thanks Problem solved

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources