| Thread | Last Post | Replies |
|
| DB Access from Within CLR UDF | 28 Jul 2006 17:21 GMT | 5 |
I'm attempting to return data from the database within a UDF. How many times can I connect and return data from the database within a UDF? So far I'm only able to do it once. On the second trip into the database, I'm getting "This statement has attempted to access data whose ...
|
| Painfully Slow Deploy Process | 25 Jul 2006 13:58 GMT | 1 |
We have a project that contains approx 80 CLR stored procs. When we deploy this assembly to the SQL Server (across a normal 100base network with very little traffic on it) it can take up to 20 minutes to complete. During this time VS2005 responds very slowly or not at all,
|
| This Newsgroup missing in Google Groups | 24 Jul 2006 16:59 GMT | 5 |
Why is this newsgroup missing in Google Groups? Google says to contact the group owner in that the group may have been removed from the Google Groups index. Thanks,
|
| DatePart result discrepancies when calculating ISO8601 week | 23 Jul 2006 15:26 GMT | 1 |
I was looking for a CLR and T-SQL solution to calculate ISO8601 week code when I ran into a post your team has made here: http://blogs.msdn.com/sqlclr/archive/2005/11/11/491981.aspx Since we are still using SQL2000 and have not yet made the immediate
|
| WMI Classes - Using | 21 Jul 2006 18:06 GMT | 2 |
I'd like to capture eventlogs and store them in a SQL database. However, using the out-of-the-box event log classes in .Net framework 2.0, every time I read an event log, the whole thing comes back. This is unwieldy as some event logs can retain MB of information. I just need to ...
|
| How to use a credential mapped to a SQL Login in a CLR stored procedur | 11 Jul 2006 07:01 GMT | 2 |
I have created a credential with he CREATE CREDENTIAL statement and mapped it on a login for SQL Server authentication. I want to use this credential now in a CLR stored procedure. I thought that if I then logon with the sql server login that the SqlContext.WindowsIdentity ...
|
| strong name exception when calling stronly named assembly | 10 Jul 2006 22:22 GMT | 1 |
I have a dotnet assembly that I have loaded into SQL 2005. It is a strongly named assembly. I can use this assembly just fine within an executable (ie strong naming doesn't fail on the desktop or in the IIS environment) I have created a second assembly (as a clr stored proc) that ...
|