My advice on this would be to not use CLR for it. TSQL is best suited for this operation. You will lose performance pulling the data into the...

To understand what is happening here, you really have to have a understanding of how the MTL is allocated at startup, and how it is consumed later on. I...

Take a look at the SqlDependency Class in .NET 2.0.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency.aspx

You can register a dependency object in an external app that triggers an event when the data changes in the database....

I am surprised that PSS didn't tell you up front that the assembly you are trying to load is unsupported in SQL Server, and you shouldn't be using it in...

Paul,

did you happen to get this working, or are you still having trouble?

Abstract the logic that you want to use inside SQL Server to a new assembly and restrict it to the approved assembly list only. That is the only alternative...

If this was a homework assignment, then you have a bad teacher if this is the kind of implementations of SQLCLR that they are teaching. Others here will agree...

You don't need a CLR object to do this. You can do it in TSQL completely, and with much better performance. If you are new to SQL Server,...

The EXECUTE AS is SQL Based, not CLR Based Impersonation. You would still be operating as the SQL Service account exterior to SQL Server. Making the windows identity...

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.