Doris Manning
mikedorism at verizon.net
Sat Jul 4 08:39:41 CDT 2009
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