I am trying to create a function in C# and have it called from SQL Server as a DB Function
This is what i have already done..
1)Created a Class Library Project in VS 2005 Express
2)Created the class with the attached code and compiled to get the .dll file
3) Created new Assembly on SQL Server with dbo as owner and pointing to the .dll as the CLR assembly
4)Called the function with select dbo.Sample()
But i received the following error message
Msg 4121, Level 16, State 1, Line 1
Cannot find either column "dbo" or the user-defined function or aggregate "dbo.Sample or the name is ambiguous.
Am doing anything wrong in the steps?
public class RegExBase
[SqlFunction(IsDeterministic = true, IsPrecise = true)]
public static bool Sample()