.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.
-
Answered1Votes
Unable to add the PresentationFramework assembly
Hello I am in the process of creating a CLR Function. One of the assemblies that I need to use for my CLR function is the PresentationFramework ...15 Replies | 204 Views | DanCoxLFC - Monday, June 17, 2013 9:30 AM | Last Reply Erland Sommarskog - Friday, June 21, 2013 3:57 PM -
Proposed0Votes
AddWithValue issue - Update the current field content
I have a shopping cart where when an item is "Removed" from the cart, the corresponding Database field "NewTotal" is updated with the amount removed. So, ...1 Replies | 46 Views | SmokinJoe455 - Friday, June 21, 2013 11:27 AM | Last Reply Dan Guzman - Friday, June 21, 2013 12:34 PM -
Unanswered0Votes
ALTER ASSEMBLY and Continuous Integration
I have a small assembly of scalar SQL functions built in .NET that I've manually integrated to SQL Server with CREATE ASSEMBLY and then CREATE FUNCTION. However, as part of my continuous ...1 Replies | 86 Views | Brian Sayatovic - Tuesday, June 18, 2013 12:33 PM | Last Reply GladToHelpYou - Friday, June 21, 2013 1:27 AM -
Discussion0Votes
hi
hi i am new in this laguange and i wantto be agreat programmer of the ASP.NET language help me out1 Replies | 40 Views | Rohit8750 - Thursday, June 20, 2013 9:18 AM | Last Reply Olaf Helper - Thursday, June 20, 2013 9:23 AM -
Unanswered0Votes
SQLServer2012: Load CLR Assembly Targeting Framework 2.0
Hi i have a .Net Assembly (say Dummy.dll) that depend on a few CLR 2.0 Assemblies (DepA.dll, DepB.dll) that depend on v2.0 System ...8 Replies | 4923 Views | sschoenb - Thursday, May 24, 2012 11:33 AM | Last Reply Zambodi - Thursday, June 13, 2013 6:38 PM -
Answered0Votes
More records (table with one Varchar Max column) causes deadlock with windows services
Hi, I have a windows service for sending emails by reading email contents from a table including the body (Varchar Max with 40000bytes of data). The windows service will update the ...3 Replies | 7738 Views | UllasKP - Tuesday, June 21, 2011 6:25 AM | Last Reply UllasKP - Wednesday, June 12, 2013 6:43 AM -
Unanswered0Votes
Different version in GAC and SQL
I have imported .NET 2.0 assemblies into SQL server. Everything worked. I haven't install anything to GAC. Then somebody has installed the new version of ...1 Replies | 244 Views | simonxy - Thursday, June 06, 2013 12:59 PM | Last Reply GladToHelpYou - Tuesday, June 11, 2013 6:31 AM -
Proposed0Votes
Could not Load File or Assembly 'Microsoft.sqlserver.connectioninfo, version 10.0.0.0, culture:neutral, publickeytoken:*string number*
I keep getting this error whenever I try to make a table for a local database in Visual C# Express. I'm trying to make a Windows Form Application following a book called 'Headfirst C#', I'm ...5 Replies | 185 Views | DangitBobby - Sunday, June 09, 2013 4:22 PM | Last Reply Allen Li - MSFT - Tuesday, June 11, 2013 2:11 AM -
Answered0Votes
Unable to load System.IdentityModel.dll assembly into SQL Server 2012
Hello, I try to load an assembly which refers to 'System.IdentityModel.dll' (because it uses WCF) into SQL Server 2012 Express 64Bit. I get always this error ...14 Replies | 5870 Views | Timo Hein - Monday, October 22, 2012 9:18 AM | Last Reply davidbaxterbrowne - Monday, June 10, 2013 1:58 PM -
Answered0Votes
clr function with error A .NET Framework error occurred during execution of user-defined routine or aggregate "funAFTN_GetFilesFromDirectory": System.IO.IOException: Logon failure: unknown user name or bad password.
hi i create a .dll in asp.net and it shoud read files on network when i use it in asp it works well and can read all files from network and i ...3 Replies | 175 Views | sheriiishoor - Saturday, June 08, 2013 11:59 AM | Last Reply Erland Sommarskog - Sunday, June 09, 2013 9:13 AM -
Discussion0Votes
Join Microsoft -- China-Beijing
Microsoft IT Making IT happen. Improving the way people work is our daily motivation. We start with the best talent and add leading process and information technologies ...0 Replies | 189 Views | Netty Zhang - Monday, June 03, 2013 8:44 AM -
Unanswered0Votes
CLR SP sometimes raises severe error
I have pretty complex CLR stored procedure which opens external connections and calls T-SQL procedures to read and update data. Usually it works fine but sometimes it ...5 Replies | 258 Views | GApokrif - Wednesday, May 29, 2013 1:44 PM | Last Reply Erland Sommarskog - Thursday, May 30, 2013 9:27 PM -
Answered0Votes
A question about Microsoft.SqlServer.SqlParser.dll
Hi all, I found this library in SSMS 2008 assemblies, it can parse T-SQL statements into structured XML as ...5 Replies | 8577 Views | UEHOO - Sunday, September 05, 2010 1:31 AM | Last Reply Michael Søndergaard - Sunday, May 26, 2013 8:56 PM -
Answered2Votes
Generating pdf files from inside the db
I would like to investigate performance and difficulties related to generating pdf files using a .Net CLR procedure. Assume a situation where you have ...3 Replies | 329 Views | Bjorn D. Jensen - Wednesday, May 22, 2013 12:20 PM | Last Reply Olaf Helper - Wednesday, May 22, 2013 12:52 PM -
Proposed2Votes
CREATE ASSEMBLY failed because it could not open the physical file (The device is not ready.).
I have a simple class libarray that I have compiled into DLL using csc.exe Source code is as follows: - using ...10 Replies | 21523 Views | Imtiaz3 - Friday, March 23, 2007 1:59 AM | Last Reply Shahgholi Ardalan - Wednesday, May 22, 2013 6:14 AM -
Answered0Votes
SQL Server Common Language Run-time Integration for Visual Studio 2012
Is there currently no SQL Server CLR Integration for VS 2012? The MSDN article refers to VS 2010 only. It looks like I will have to install VS 2010 alongside VS 2012 then.2 Replies | 442 Views | Christopher Tso - Saturday, May 11, 2013 1:57 PM | Last Reply Christopher Tso - Sunday, May 12, 2013 1:15 AM -
Unanswered0Votes
sql stored procedure and static block of data
Hi, My stored procedure is built in C# and deployed to SQL server as a dll. So I thought there should be some DLL initialization routine that ...4 Replies | 469 Views | Boyd1 - Thursday, May 09, 2013 3:37 PM | Last Reply davidbaxterbrowne - Friday, May 10, 2013 5:33 PM -
Answered0Votes
WindowsImpersonationContext - how to get current SQL user in CLR function
Hi Folks, I have a SQL CLR function that needs to call an external application. The database has SET Trustworthy=ON, and the CLR function is being called as an UNSAFE ...7 Replies | 458 Views | AndyW2007 - Tuesday, April 30, 2013 1:20 AM | Last Reply AndyW2007 - Friday, May 10, 2013 3:39 AM -
Unanswered0Votes
CLR SQL function returning nvarchar max shows null reference exception.
Hi, I have created a CLR sql function with return type as varchar(max) using the following ...5 Replies | 571 Views | joby003 - Monday, May 06, 2013 7:34 AM | Last Reply joby003 - Tuesday, May 07, 2013 5:58 AM -
Answered0Votes
Compatible SQLCLR version for various SQL server
Hi, I could not find any documentation on what SQL CLR version is supported on various SQL Servers. We have a project which uses CLRs stored procedures and is expected to support ...2 Replies | 447 Views | AkashCPatel - Wednesday, May 01, 2013 3:11 PM | Last Reply Allen Li - MSFT - Thursday, May 02, 2013 8:16 AM - Items 1 to 20 of 2371 Next ›