January 11, 2009 at 10:07 pm
This may be a stupid question, but how do I enable crl triggers? I read simple instructions on the net, but they assume the person knows where to actually write the statement.
I right click my database, then hit "New query". When the query window pops up, it's blank. The article then said to use this code:
sp_configure 'clr enabled', 1
Go
RECONFIGURE with Override
Go
However when I hit the "execute" button at the top, I get this:
Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.
What do they mean when they say "Run the RECONFIGURE statement to install" I thought by hitting the execute button it was installed. Do I need to do something else?
I'm fairly new at this and I hate to try something that will destroy my database.
January 11, 2009 at 11:27 pm
The message "Run the RECONFIGURE statement to install" came from the first SQL statement "sp_configure 'clr enabled', 1".
As you are already executing the "RECONFIGURE" command just after the SQL asks you to do so you are good to go. The CLR is enabled on your server.
RECONFIGURE with Override updates the current values with the new value that you have assigned using sp_configure (in the first statement).
To read more about RECONFIGURE check BOL.
-Vikas Bindra
January 11, 2009 at 11:31 pm
What are you looking to do with the CLR?
In most circumstances, especially when dealing with data access, T-SQL outperforms CLR procs/function
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply