SQL Server 2005General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
Cannot find the object 'Normalizar', because it does not exist or you do not have permission.
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Normalizar", or the name is ambiguous.
I tried also to see the function using SQL Server Management Express, but I didn't find it.
My project is an Sql Server 2005 project. I have the default debug script "test.sql", which contains the grant and select commands, and also all the table creates that works fine, and I can locate with the Sql Server Management Express.
My UDF is a C# file: "Normalizar.cs", but it seems the deployment doesn't build the function in the server, or I don't know how to see it.
I finally succeded. The problem was that my initial catalog in the project's DB connection was the master database. And I created the assembly in this database, but my test.sql also creates and uses a new database, and cannot find the UDF in this DB.
After changing the connection, I can use my UDF in my own database.