What exactly is your application doing, and what is it written in? This kind of information is best implemented not in CLR but with standard DDL Triggers. The...

What type of CLR object is this? A Trigger/Stored Procedure?

More thn anything else, UDT's and UDF's are easily used out side of SQL. This is of great benefit for things like geocoding where the UDT is used as...

Akeelm,

Looking at your trigger, it has a common mistake that I see in both TSQL and CLR triggers. It only handles a single row, so if you have more...

Generally speaking this is accomplished with an Active Directory Domain Users Group. You add the AD Group to SQL Server as a Login, and then grant the correct rights...

(1) Create a new schema that will hold the SQLCLR objects

(2) Create an asymmetric key from the assembly dll

(3) Create a login from the asymmetric key

(4) Grant EXTERNAL-ACCESS-ASSEMBLY permissions to...

If you want to use the Logic from a CLR Stored Procedure outside of SQL Server, you need to code it for such a purpose. I generally abstract the...

Thank you for the information.  It worked perfectly.

Jon

I resolved this with a good bit of research last night.  The solution is:

Original Code:

Public Function GetSelections(ByRef prmListBox as object) as String

 Dim intCount as Integer

 Dim strSelectedValues as String

 strSelectedValues = ""

 For...

I just encountered this today when moving a database from my production environment to my development environment.  This is caused by what appears to be a difference in the 2005...