.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.
-
1 VotesStrange results in SQL 2005 with CLR UDF and Varbinary(MAX)
I have an empty C# CLR UDF that looks like this: public static SqlBytes MyUDF(SqlBytes data) { return data; } Defined like ...Answered | 3 Replies | 2213 Views | Created by Neil Weicher - Friday, February 7, 2014 8:16 PM | Last reply by Kazzman - Wednesday, October 2, 2019 12:40 PM -
0 VotesDatabase connection issue
Hi there, I am trying to connect server database in my web api. While doing this I am getting following error in Postman. "Could not get ...Unanswered | 1 Replies | 172 Views | Created by Nihar86 - Friday, September 27, 2019 12:51 PM | Last reply by Olaf Helper - Friday, September 27, 2019 1:07 PM -
0 VotesCan I connect SQL Server 2005 to Visual Studio Community 2019 / Visual Studio Code?
I was assigned to develop an asp.net with the database in SQL Server 2005. Can Visual Studio Code or Visual Studio 2019 Community connect with SQL Server 2005?Unanswered | 3 Replies | 213 Views | Created by xokin - Tuesday, September 24, 2019 4:21 AM | Last reply by Olaf Helper - Wednesday, September 25, 2019 5:35 AM -
0 VotesBeing able to write a sql clr function that will script the procedure/view/function/trigger in sql server as a different object name
I was thinking I can do this using Microsoft.SqlServer.TransactSql.ScriptDom , Passing a SQL definition of the object to the clr function using this dll and change change passed sql (which can be ...Unanswered | 6 Replies | 268 Views | Created by GV1973 - Tuesday, September 17, 2019 2:48 PM | Last reply by Stefan Hoffmann - Wednesday, September 18, 2019 10:03 AM -
0 Votes.NET Workflow Persistance
Dear Sir/Madam, Could you please confirm when we upgrade VS 2010/SQL 2012 to VS 2017/SQL 2016, with workflow persistence store, implemented using customer activities and .xamlx ... -
0 VotesMSSQL Query between 2 Dates
Hello I'm working on programm for presence control e.g ID - ...Unanswered | 5 Replies | 451 Views | Created by DataProTec1 - Friday, August 30, 2019 8:21 AM | Last reply by Erland Sommarskog - Sunday, September 1, 2019 7:47 PM -
0 VotesSQL Database slowness
Hello, I'm not sure if this is right place to post a threat for SQL DB slowness issue. Our front end is .Net Framework. When I was looking ...Discussion | 1 Replies | 571 Views | Created by JinalContractor - Tuesday, August 27, 2019 3:43 PM | Last reply by Erland Sommarskog - Tuesday, August 27, 2019 9:14 PM -
0 VotesCLR and Indexed view
I am trying to create a non-clustered index an a CLR-derived column in an indexed view, but it doesn't allow me. Here is the error message: Cannot create index or statistics ...Answered | 3 Replies | 11599 Views | Created by Stimo - Friday, June 3, 2011 1:52 PM | Last reply by Pxtl - Tuesday, August 20, 2019 4:03 PM -
0 VotesMS SQL2012 and TLS version 1.2
We have a few SQL2012 servers with .NET 4.03. The company was bought out by another company and that company , using Rapid7 security scanning, has discovered that our SQL Servers are ... -
0 VotesHow to Call a Function in a dll built in higher version of .NET
I have a CLR assembly built in .NET 3.5 in a SQL Server 2008R2. I need to be able to call a function in a .NET dll built in .NET 4.6.1. I can't reference the dll from my CLR project, as I get errors ...Answered | 5 Replies | 637 Views | Created by Alphonse G - Tuesday, July 23, 2019 2:08 AM | Last reply by Alphonse G - Monday, August 5, 2019 6:39 PM -
0 VotesIs there no way to Slipstream 2012 all the way from RTM to SP4?
I've seen multiple sites referencing FULL-Slipstream ready files for SP4, but I've only been able to find the FULL-Slipstream ready files for SQL 2012 SP1. Is there no way to Slipstream from RTM to ...Unanswered | 1 Replies | 505 Views | Created by jbrivers7 - Wednesday, July 31, 2019 6:53 PM | Last reply by Tom Phillips - Wednesday, July 31, 2019 7:02 PM -
0 VotesIntermittent "A network-related or instance-specific error occurred while establishing a connection to SQL Server"
Hello, A single customer of ours is experiencing an intermittent SQL Server connection problem with out ASP.NET 4.6.2 WebForms application. Most of the time, things work just fine. ...Unanswered | 1 Replies | 493 Views | Created by AppDev2019 - Thursday, July 25, 2019 2:18 PM | Last reply by Erland Sommarskog - Thursday, July 25, 2019 9:52 PM -
0 Votesthe underlying provider failed on open
I am having a nightmarish start on my first program.when i finished my program i used innosetup and put all the required files including the database for me me to make a setup file.When ever i install ...Unanswered | 4 Replies | 557 Views | Created by mcfee12345 - Tuesday, July 23, 2019 9:50 AM | Last reply by Olaf Helper - Tuesday, July 23, 2019 11:27 AM -
0 VotesTime autosave
Hi.How to save the date of update and creation of data in the database automatically? I am using codefirst.tanksfull.Unanswered | 1 Replies | 516 Views | Created by Ali_Lonbar - Monday, July 22, 2019 6:30 AM | Last reply by Olaf Helper - Monday, July 22, 2019 9:04 AM -
0 VotesError using Sql Server in Windows Service
Hi, I am trying to connect to local SQL Server from Windows Service application but getting below error. The same code i am using with Windows Form application ...Unanswered | 1 Replies | 631 Views | Created by Jassim Rahma - Friday, July 19, 2019 11:51 PM | Last reply by Erland Sommarskog - Saturday, July 20, 2019 7:57 AM -
0 VotesUnable to view all data using linked server between two Azure Managed Instances
I am unable to view all data using linked server between two Azure Managed Instances. I have two managed instances MI1 and MI2. I created a linked server on MI2 to access ...Unanswered | 3 Replies | 748 Views | Created by Sylviarf - Wednesday, July 3, 2019 5:26 AM | Last reply by Sylviarf - Wednesday, July 17, 2019 11:57 PM -
0 Votesto sql_connection.Open() or .sql_connection.OpenAsync()?
Hi, Can someone explain is it better to use sql_connection.Open() or sql_connection.OpenAsync()? For example in WinForm? Website? Mobile ...Unanswered | 1 Replies | 587 Views | Created by Jassim Rahma - Tuesday, July 16, 2019 8:57 PM | Last reply by Erland Sommarskog - Tuesday, July 16, 2019 9:17 PM -
0 VotesConnection string for MVC 5 with SQL Enterprise
As the question is really about MVC 5, there may be a better forum to ask this question but the error is a SQL Error 26. I've tried a host of connection ...Answered | 2 Replies | 715 Views | Created by Crakdkorn - Sunday, July 14, 2019 3:49 PM | Last reply by Crakdkorn - Sunday, July 14, 2019 9:01 PM -
0 VotesNew windows 10 patches affect VM image spinned on windows server 2012
New Windows 10 patches affect Virtual machine running on windows server 2012 -
0 VotesSQL Server - Other way of getting the information from AD without using OLE for asp.net project
Application is using OLE automation feature to get user information from Active Directory, which detected as security vulnerability. It is using SP_OACreate, ...Proposed | 1 Replies | 646 Views | Created by rxgupta - Thursday, July 4, 2019 10:53 AM | Last reply by SimpleSQL - Thursday, July 4, 2019 10:56 AM - Items 1 to 20 of 2905 Next ›
.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.
