How are you reading the cert back into your CLR code? Can you post an example of your code that does this? You can try using Windows Identity...

Rather than trying to have SQL pull from the GAC, create the assemblies from a local folder path explicitly.

What you have posted is all TSQL, and not CLR. What are you trying to do in CLR specifically? What version of Visual Studio are you using?

Its not a SQL Solution, but you can do it in your .NET application by enumerating the DataGridView.Rows collection and for each DataGridViewRow look at the column you want by...

It would help to have some example input and output data to work with to solve your question. Please see the following article where Jeff Moden offers some tips...

Without seeing the TSQL statement that you are running, it is difficult to say what the problem may or may not be.

First, make sure that a valid Login is the owner of the database. For instance, in my environment, I belong to a DBA Active Directory group which is a...

To keep your CLR Assembly scalable, you might consider using a Enum of acceptable file types. Then your procedure could validate that the filetype provided is in the acceptable...

The multi server query is actually executed as separate batches on each server, so any statements being run are still batch scoped which means they will complete inside their respective...

This statement is...

You can try to add the -g384 or -g512 startup parameter to see if it is a memory leak causing the problems. I have one CLR object that interacts...

Thomas LaRock (8/18/2008)

---

hi denby,

we try to limit the use of CLR here, simply because it does not seem to be necessary. however, one caveat that i have seen has to...

Did you change the safety level of the Assembly on the Deploy tab to External_Access? You can check this from SQL Management Studio by expanding the database, Programability, Assemblies,...

It will be in the projects solution folder in the bin\Debug or bin\Release folder as appropriate for the type of build you did. You have to then copy the...

The Login and user that you create from the certificate have nothing to do with the permissions that the CLR runs under. They exist solely to allow you to...