All, I have a unique problem. In SQL 2000 there is a way to convert a function to being a system function. I.E. instead of master.dbo.listToTable() you could use fn_listToTable(). The same conversion of a function doesn't work in SQL 2005. This is causing a problem because we are upgrading from a SQL 2000 db to a SQL 2005 db and we can't create the common functions that we use across all of the databases. Does anyone know how to do this in 2005? Steve Steve Durette SR IT Analyst 586-466-7654 [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303196 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
