.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.
-
Unanswered0VotesSQL Server Create data about time always get "0001/1/1 0:00:00"
In my ASP.NET project,there is a filed about time in a data table (SQL Server 2008).Its type is "datetime",default value "getdate()". It worked well. While I change the type ,and ... -
Unanswered0VotesALTER 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 ... -
Unanswered0VotesSplit String into Multiple Rows with Position ID
0 Begin Set @Pos = CharIndex(@Delimiter, @List) If @Pos = 0 Set @Pos = Len(@List) + 1 Set @Item = Left(@List, @Pos - 1) Insert @Items Select ... -
Unanswered0VotesUnable 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 ... -
Unanswered0VotesSQLServer2012: 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 ... -
Answered0VotesMore 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 ... -
Unanswered0VotesDifferent 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 ... -
Proposed0VotesCould 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 ... -
Answered0VotesUnable 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 ... -
Answered0Votesclr 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 ... -
Discussion0VotesJoin 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 ... -
Unanswered0VotesCLR 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 ... -
Answered0VotesA 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 ... -
Answered2VotesGenerating 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 ... -
Proposed2VotesCREATE 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 ... -
Answered0VotesSQL 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. -
Unanswered0Votessql 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 ... -
Answered0VotesWindowsImpersonationContext - 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 ... -
Unanswered0VotesCLR 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 ... -
Answered0VotesCompatible 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 ... - Items 1 to 20 of 2371 Next ›


