Viewing 10 posts - 946 through 956 (of 956 total)
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 2, 2008 at 4:52 pm
What type of CLR object is this? A Trigger/Stored Procedure?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 2, 2008 at 4:45 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 28, 2008 at 8:20 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 27, 2008 at 9:45 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 27, 2008 at 8:36 pm
(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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 27, 2008 at 8:20 pm
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 27, 2008 at 8:17 pm
Thank you for the information. It worked perfectly.
Jon
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
July 24, 2007 at 7:17 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
June 14, 2007 at 7:33 am
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...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
April 5, 2007 at 11:24 am
Viewing 10 posts - 946 through 956 (of 956 total)