.NET Framework inside SQL Server announcement
-
Link
This forum covers questions regarding .NET assemblies and database objects running as part of SQL Server including user-defined types, user-defined aggregates, UDFs, triggers, and stored procedures implemented in .NET code. supported by SQL Server 2005 and later versions. Other questions regarding SQL Server database access and other related technologies should be directed to the most appropriate forum to obtain the best response.
Questions on SQL Server .NET Client (SqlClient) data access should be posted to the ADO.NET data provider forum: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/threads
Questions on using SQL Server with ASP.NET should be posted to the ASP.NET forums: http://forums.asp.net/
Questions on writing Transact-SQL code, including T-SQL stored procedures, UDFs, and triggers: http://social.technet.microsoft.com/Forums/en-US/transactsql/threads
Questions on installation problems pertaining to .NET installations should be posted to the SQL Server Setup and Upgrade forum: http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/threads
Questions on problems using SQL Server Data Tools: http://social.technet.microsoft.com/Forums/en-US/sqltools/threads
Questions on using other Data Access APIs (e.g. ODBC, OLE DB): http://social.technet.microsoft.com/Forums/en-US/sqldataaccess/threads
Questions on writing code for SQL Server Compact Edition: http://social.technet.microsoft.com/Forums/en-US/sqlce/threads
Questions on SQL Server Express-specific issues: http://social.technet.microsoft.com/Forums/en-US/sqlexpress/threads
Questions that are off-topic in this forum may be moved to one of the other, more relevent, forums to ensure the best, most prompt response and facilitate forum-specific searchng for similar questions that have already been resolved.
-
Unanswered0VotesDate Calculation.
Adding +1 and -1 one month in a Date Add -1 Month in date '12/31/2010' date format is MM/DD/YYYY Using the below ...3 Replies | 38 Views | Created by Shukla Saurabh - 2 hours 26 minutes ago | Last reply by Tom Phillips - 12 minutes ago -
Unanswered0VotesThreads in CLR
I have a CLR table function that works fine but trying to improve its performance by using some threading. I have the following code working but my WaitAll doesn't work when it is ...22 Replies | 342 Views | Created by Jeff573 - Monday, December 02, 2013 2:35 PM | Last reply by Jeff573 - 16 hours 15 minutes ago -
Answered0VotesDeserialization permissions error in CLR stored procedure
Environment: SQL Server 2008 R2 standard edition and VS2010, .Net Framework 3.5 I've got a table with a varbinary column that contains a serialized Hashtable. I'm writing a CLR ...3 Replies | 118 Views | Created by Tom Dacon - Wednesday, December 04, 2013 9:55 PM | Last reply by Tom Dacon - 19 hours 57 minutes ago -
Unanswered0VotesAssembly policy
I have moved from SQL2008 to SQL2012, but can't my assembly doesn't work any more. When i would like to install the same assemblies as in SQL 2008, which ...3 Replies | 129 Views | Created by simonxy - Monday, December 09, 2013 4:28 PM | Last reply by simonxy - Thursday, December 12, 2013 9:13 AM -
Unanswered0VotesCLS programming - WHY?
What is the purpose of using CLS programmingin dotnet? What context shall I use CLS programming? what is the cons for using CLS?1 Replies | 75 Views | Created by Sakura Data - Wednesday, December 11, 2013 1:54 PM | Last reply by Olaf Helper - Wednesday, December 11, 2013 5:49 PM -
Unanswered0VotesAccess to SQL Server CLR
Hi, I have SQL Server 2012 Developer Edition. I ran the following code below. However, I still cannot see, do not have access to Visual Basic and Visual C# ...3 Replies | 115 Views | Created by JamesHarding45 - Tuesday, December 10, 2013 5:56 PM | Last reply by JamesHarding45 - Tuesday, December 10, 2013 8:37 PM -
Unanswered0VotesCreate excel file and send email
I have assembly in SQL2008, which creates excel file on disk, based on result set from procedure. The code is: CREATE PROCEDURE ...2 Replies | 108 Views | Created by simonxy - Monday, December 09, 2013 7:49 PM | Last reply by simonxy - Tuesday, December 10, 2013 1:24 PM -
Answered0VotesCall web service from CLR
Thanks all for suggestions, I have decided to write CLR SP to call web service. I have few question a)I am using SQL 2012 and VSTS 12 to write CLR SP in Database project ...1 Replies | 87 Views | Created by gpshukla - Thursday, December 05, 2013 2:28 PM | Last reply by Bob Beauchemin - Thursday, December 05, 2013 8:47 PM -
Answered2VotesDatabase Schemas and "This statement has attempted to access data whose access is restricted by the assembly."
Hello. In reference to my post yesterday which got removed when i edited this one: After trying a few things i realized that the reason i was getting the error "Invalid use of side-effecting or ...4 Replies | 17917 Views | Created by krypton355 - Thursday, July 14, 2005 10:37 PM | Last reply by kdpo - Tuesday, December 03, 2013 9:36 PM -
Unanswered0VotesAfter working for a while an SQLCLR assembly wont load
I have a user defined aggregate function in an assembly called Watchdog. I use that function in a stored procedure. All the sudden after running just fine for a ...8 Replies | 726 Views | Created by Hans E. Molin - Thursday, October 03, 2013 11:49 AM | Last reply by Bob Beauchemin - Tuesday, December 03, 2013 4:30 PM -
Unanswered0VotesSQL server CLR creation error "Failed to create AppDomain"
We have a CLR stored procedure registered on all different SQL environment which was working perfectly. But one SQL server 2008R2 instance throw an exception while creating CLR ...4 Replies | 344 Views | Created by PraviN_PandiT - Friday, November 15, 2013 6:26 AM | Last reply by PraviN_PandiT - Tuesday, December 03, 2013 4:53 AM -
Answered0VotesDoes "set nocount on" affect a CLR procedure
Hello I have a CLR procedure, which uses the methods SqlDataAdapter.Update() and SqlCommand.ExecuteNonQuery(). The CLR procedure is called by a Transact SQL ...5 Replies | 196 Views | Created by saxeten - Wednesday, November 27, 2013 8:42 AM | Last reply by saxeten - Thursday, November 28, 2013 8:20 AM -
Unanswered0VotesCLR Stored Procedure with WMI call getting Access Denied error when trying to connect to remote computer
Hi, I created a clr stored procedure with some wmi calls and trying to connect to remote system and getting the following ...4 Replies | 178 Views | Created by ktreddy - Wednesday, November 27, 2013 12:34 PM | Last reply by ktreddy - Thursday, November 28, 2013 6:18 AM -
Answered0VotesSQL Server CLR Integration Compiler Error - Windows 8 Issue?
csc /target:library helloworld.cs Microsoft (R) Visual C# Compiler version 4.0.30319.33440 for Microsoft (R) .NET Framework ...1 Replies | 150 Views | Created by arabianrhino - Wednesday, November 27, 2013 9:57 PM | Last reply by Bob Beauchemin - Thursday, November 28, 2013 12:06 AM -
Unanswered0VotesCREATE ASSEMBLY failed because type 'Microsoft.FSharp.Collections.FSharpMap
CREATE ASSEMBLY failed because type 'Microsoft.FSharp.Collections.FSharpMap`2' in safe assembly 'FSharp.Core' has a static field 'empty'. Attributes of static fields in safe assemblies must be marked ...2 Replies | 120 Views | Created by somasekaranmc - Wednesday, November 27, 2013 7:50 AM | Last reply by somasekaranmc - Wednesday, November 27, 2013 9:15 AM -
Proposed0Votes.NET Framework error occurred during execution of user-defined routine or aggregate " ": System.Net.WebException: The operation has timed out
Hello, I executed a stored procedure that prints a report which comes back with an error message when the query lasts about 1:40min, but the my order prints. I don't why I get that ...4 Replies | 423 Views | Created by JoseFleitas - Friday, November 08, 2013 9:47 PM | Last reply by JoseFleitas - Monday, November 25, 2013 2:55 PM -
Unanswered0VotesConverting strings to buffers and back again (C# and C/C++ and SQL Server)
0) *dataIn++ ^= 0xFF; } /* MY_XOR.CS */ [DllImport("mydll.dll")] static extern void _my_xor(byte[] dataIn, int ...2 Replies | 233 Views | Created by Neil.W - Monday, November 18, 2013 9:05 AM | Last reply by Christian HL - MSFT - Wednesday, November 20, 2013 3:58 AM -
Proposed3VotesAttempted to perform an operation that was forbidden by the CLR host.
Hi all, I am using SQL server 2005 - 9.00.1399.06 (Intel X86) I have written one generic CLR trigger for Audit. I have deployed the assembly through VS2008 ...9 Replies | 18344 Views | Created by Prabodh Sawant - Tuesday, December 30, 2008 5:49 AM | Last reply by ghendric - Wednesday, November 13, 2013 3:00 PM -
Answered0VotesSSDT project with standard assemblies.
I have old project that uses WCF from withing C# CLR triggers for SQL Server. I was always installing it by running a script. But I've decided to move on to SSDT ...2 Replies | 265 Views | Created by Shemshurenko Alex - Sunday, November 10, 2013 8:20 AM | Last reply by SandeepChalke - Wednesday, November 13, 2013 1:26 PM -
Answered0VotesCLR Stored procedure consume webservice
Can you have a CRL stored procedure call a webservice that returns a dataset?6 Replies | 8370 Views | Created by ZDB - Wednesday, November 08, 2006 6:29 PM | Last reply by davidbaxterbrowne - Tuesday, November 12, 2013 3:58 PM - Items 1 to 20 of 2427 Next ›


