jwcolby
jwcolby at colbyconsulting.com
Sat Jul 4 09:01:21 CDT 2009
Well... I put master.dbo.MyUDFName and it worked just fine. John W. Colby www.ColbyConsulting.com jwcolby wrote: > BTW I designed the UDF in the Master database in the hopes that it would be visible from any other > database when it was time to do an update query. > > John W. Colby > www.ColbyConsulting.com > > > Doris Manning wrote: >> Dbo.uf_AddrValid >> >> -----Original Message----- >> From: dba-sqlserver-bounces at databaseadvisors.com >> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby >> Sent: Saturday, July 04, 2009 9:36 AM >> To: Dba-Sqlserver >> Subject: [dba-SQLServer] Testing UDFs >> >> I am jumping into writing UDFs this morning. I need to test the results. >> When I write a query to pull data from a table using the UDF as one of the >> columns (just to display what happens) I get: >> >> "uf_AddrValid not a recognized built-in function name." >> >> Is there a naming convention to allow SQL Server (2005) to understand my UDF >> and use them? I know that there was a prefix I had to use in stored >> procedures. >> >> -- >> John W. Colby >> www.ColbyConsulting.com >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> >> >> _______________________________________________ >> dba-SQLServer mailing list >> dba-SQLServer at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver >> http://www.databaseadvisors.com >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >