The answer is that you cannot do the equivalent of PRINT ‘Hello World’ from inside a [SqlFunction()]. You can do it however from a [SqlProcedure()] using SqlContext.Pipe.Send(“hello world”) This is consistent with T-SQL, where you would get the error “Invalid use of a side-effecting operator ‘PRINT’ within a function” if you stick a PRINT inside … Read more
Ran the SQL commands below and the issue appears to be resolved. USE database_name GO EXEC sp_changedbowner ‘sa’ ALTER DATABASE database_name SET TRUSTWORTHY ON
This worked for me: EXEC sp_changedbowner ‘sa’ ALTER DATABASE [dbase] SET trustworthy ON and I also did this: sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO sp_configure ‘clr enabled’, 1; GO RECONFIGURE; GO sp_configure ‘show advanced options’, 0; GO RECONFIGURE; GO
Check out the sys.assembly_modules view: select * from sys.assembly_modules This should list all functions and the assemblies they’re defined in. See the Books Online help page about it. Returns one row for each function, procedure or trigger that is defined by a common language runtime (CLR) assembly.
All of the various database objects are now created inside of SQL Server database projects. They’ve removed the distinction between database projects (SQL Scripts) and SQL CLR projects. So it’s just File -> New -> Project, Installed -> Templates -> SQL Server, SQL Server Database Project. Then, if you go to Add -> New Item, … Read more
Try CREATE FUNCTION NormalizeString(@s nvarchar(max), @normalizationForm nvarchar(50)) RETURNS nvarchar(max) AS EXTERNAL NAME CLRFunctions.[CLRFunctions.T].NormalizeString
Assemblies with EXTERNAL_ACCESS are, through some convoluted path, falling under the EXECUTE AS path. The problem appears when the ‘dbo’ cannot be mapped to a valid login. dbo’s login is the login with the SID the owner_sid value in sys.databases. Unless an AUTHORIZATION clause was used in CREATE DATABASE the owner_sid is the login sid … Read more
Scalar Functions Scalar functions (sometimes referred to as User-Defined Functions / UDFs) return a single value as a return value, not as a result set, and can be used in most places within a query or SET statement, except for the FROM clause (and maybe other places?). Also, scalar functions can be called via EXEC, … Read more