[dba-SQLServer] Testing UDFs

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
> 
>