Hello,

I have and UDF called "Normalizar":

[Microsoft.SqlServer.Server.SqlFunction]
    public static SqlString Normalizar(SqlString AText)
    {
        return new SqlString(NormalizeStr((String)AText));
    }

I am trying to execute it:

select dbo.Normalizar(user);

but next message appears:

Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Normalizar", or the name is ambiguous.

Anybody can help? thanx

GRANT EXECUTE ON dbo.Normalizar TO PUBLIC ?

--Jeff Moden

Thanks, but I tried it:

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.

Thanks

But now I have other problem.

My connection:

Data Source=MOSSA-DESA\SQLEXPRESS;Initial Catalog=CDBX;Integrated Security=True

Part of my test.sql code:

USE master;

IF DB_ID (N'CDBX') IS NOT NULL
DROP DATABASE CDBX;

-- Get the SQL Server data path
DECLARE @data_path nvarchar(256);
SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
                  FROM master.sys.master_files
                  WHERE database_id = 1 AND file_id = 1);
-- execute the CREATE DATABASE statement
EXECUTE ('CREATE DATABASE CDBX ON
( NAME = CDBX_dat,
    FILENAME = '''+ @data_path + 'CDBX.mdf'',
    SIZE = 10,
    MAXSIZE = 50,
    FILEGROWTH = 5 )
LOG ON
( NAME = CDBX_log,
    FILENAME = '''+ @data_path + 'CDBX.ldf'',
    SIZE = 5MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB )'
);

My new error:

Cannot drop database "CDBX" because it is currently in use.
Database 'CDBX' already exists.

¿¿???

Really, it's not very important, because I can drop and re-create all the tables without problem.

Thanks for the feedback on the UDF problem solution.

--Jeff Moden