SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in Schemas getting duped for UDF when specifing db name      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic Schemas getting duped for UDF when specifing db name Author Message judahr Joined: 09 Mar 2007 Posts: 320 Country: United States Schemas getting duped for UDF when specifing db name 2.5.20 when you fully qualify a function using a database name and schema and select a UDF the schema is getting added again. Database.dbo.Function is resulting in Database.dbo.dbo.Function When you don't specify the database name, it works fine. Wed Aug 29, 2007 3:38 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7992 Thanks for reporting this. I am going to submit this bug to development. Hope this is a small issue and can be addressed quickly. Wed Aug 29, 2007 3:50 pm judahr Joined: 09 Mar 2007 Posts: 320 Country: United States Actually, it looks like the schema is being duplicated if the database is not specified. Wed Aug 29, 2007 4:27 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.