.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.
-
0 Votes
.net Issue Azure VM (Datacenter 2019)
I have a postgresql database application running on the server when my users try to access certain functionality they get an error that the vendor says is due to an old .net framework being installed. ...Answered | 1 Replies | 2085 Views | Created by mhager - Tuesday, August 11, 2020 5:23 PM | Last reply by Olaf Helper - Wednesday, August 12, 2020 6:39 AM -
0 Votes
SQL CLR errors after the July 2020 update
I have a large system that uses a SQL CLR component to contact a server and get XML back. It's been rock-solid until the latest update. Now instead of getting XML in it throws an error: The ...Unanswered | 0 Replies | 2011 Views | Created by Russell Shilling - Thursday, August 6, 2020 5:49 PM -
0 Votes
Foutmelding
Geachte, na de windows 10 update naar versie 2004 kan ik geen data meer uploaden naar een SQL database. Ik krijg steeds volgende foutmelding. System.InvalidCastException was ...Unanswered | 1 Replies | 2218 Views | Created by Marcel VM - Tuesday, August 4, 2020 7:50 AM | Last reply by Olaf Helper - Tuesday, August 4, 2020 9:07 AM -
0 Votes
Help needed to solve POS issue based on SQL
Hi, for many years I have been using Cash Register Express POS software that is based on SQL 2005. My server died and I had to install the software in another computer. When I try to restore the ...Unanswered | 1 Replies | 3171 Views | Created by MR Zayas - Wednesday, July 22, 2020 12:55 AM | Last reply by Olaf Helper - Wednesday, July 22, 2020 6:13 AM -
0 Votes
SQL Server 2016 SP2, Database mail not sending mails.
I have several sql server instances running SQL Server 2016, sp2 Microsoft SQL Server 2016 (SP2-GDR) (KB4532097) - 13.0.5102.14 (X64) Dec 31 2019 ...Unanswered | 6 Replies | 3437 Views | Created by Goutam Ghoshal - Monday, July 20, 2020 11:58 AM | Last reply by Goutam Ghoshal - Tuesday, July 21, 2020 7:21 AM -
0 Votes
Hi please help with syntax error "DCACCOUNTSOLD" without " " it runs and not give back results
"select * from db2 where convert(varchar(10), createtime, 112) between @fromdate and @todate and convert(xml, replace(message, ...Proposed | 6 Replies | 4225 Views | Created by Nhlahla Mike - Wednesday, June 24, 2020 9:50 AM | Last reply by pituach - Thursday, June 25, 2020 9:12 AM -
1 Votes
How to Automate .bak delete from Azure Blob?
Hi All, I have designed a solution to keep SQL Server Databases Backup to Azure Blob Storage. We want to keep only 5 Days Backup and and want to implement a cleanup process so that ...Answered | 5 Replies | 7523 Views | Created by Shivendoo Kumar Dubey - Thursday, June 18, 2020 5:00 AM | Last reply by NKO_IT - Friday, June 19, 2020 11:13 AM -
0 Votes
.Net SqlClient Data Provider for SQL Server causing 100% CPU usage on DB Server
Hi guys, Total SQL noob here. Not sure if this is the right forum, but the connector from our web servers is causing the DB server to use 100% CPU usage. I'm unable to find any ...Unanswered | 1 Replies | 3873 Views | Created by DrComputerMan - Wednesday, June 17, 2020 10:40 PM | Last reply by Olaf Helper - Thursday, June 18, 2020 7:01 AM -
0 Votes
Can't Connect to Data Source Using ODBC (.Net Core 3.0)
This is probably the wrong forum, but I can't find one related to ODBC under Windows 10. I'm trying to connect to a database via ODBC from my c# project in VS 2019 (.Net ...Unanswered | 1 Replies | 4506 Views | Created by RMittelman - Sunday, June 7, 2020 6:52 PM | Last reply by RMittelman - Wednesday, June 10, 2020 11:32 PM -
0 Votes
Can you integrate SSIS project with website?
According to my project requirements, I need to develop a few pages on the company website where the user would upload an excel sheet to transfer the data to MS SQL Server. I am getting ... -
0 Votes
sql server on linux
TITLE: Microsoft SQL Server Management Studio ------------------------------ Alter failed for SqlAssembly 'Web'. ...Discussion | 2 Replies | 3601 Views | Created by Diddda - Thursday, May 21, 2020 11:53 AM | Last reply by Erland Sommarskog - Thursday, May 21, 2020 9:24 PM -
0 Votes
Cant able to create database locally in visual studio
I struggling with network related issue while trying to create sqlserver database inside my App_folder in asp.net webapplication and In asp.net core webapplication ,while am creating migrations, at ...Unanswered | 1 Replies | 3826 Views | Created by Cevengali Shivapriya - Thursday, May 14, 2020 6:14 AM | Last reply by Erland Sommarskog - Thursday, May 14, 2020 9:17 PM -
0 Votes
Select uncommon rows based on single column in MSSQL or LINQ
I want to select a API_PATH which is not common between ADMIN and SUPER ADMIN ...Unanswered | 1 Replies | 4206 Views | Created by Madishetti Vijay - Monday, May 11, 2020 4:27 PM | Last reply by RamJaddu - Monday, May 11, 2020 4:44 PM -
0 Votes
SQL Server 2019 Connect to ASP Classic Application.
I am upgrading my database from SQL Server 2014 to SQL Server 2019. I see a challenge in connecting my ASP Classic application to SQL Server.Whenever there is a call from the ASP classic page to the ...Unanswered | 3 Replies | 4406 Views | Created by Ab_Pups - Monday, May 4, 2020 4:21 PM | Last reply by Erland Sommarskog - Monday, May 4, 2020 9:33 PM -
0 Votes
Login, AES Encryption and Decryption with SQL Server and Visual Studio C#
Hello... I am having trouble searching for answers so I hope anyone would help me here. I am making a login form on a Windows Form in Visual Studio C# where the username and ... -
0 Votes
merge column as Row base on two criteria
TABLE 1. ...Unanswered | 4 Replies | 4425 Views | Created by TrigStar2020 - Friday, April 17, 2020 9:39 PM | Last reply by Erland Sommarskog - Monday, April 20, 2020 9:27 PM -
0 Votes
Import .xlsx file into SQL table
task-> import option, it gives an error (The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.) i tried with OPENROWSET option, even that gives ...Unanswered | 2 Replies | 3937 Views | Created by v k b - Sunday, April 19, 2020 7:58 AM | Last reply by v k b - Monday, April 20, 2020 2:38 PM -
2 Votes
Average by GROUP BY in SQL Server
I am working of traffic data. I have following data Table. I want to get the average speed of all vehicles wih in every one seconds within position of every 10 meters. Data time interval is 0.2 ...Answered | 10 Replies | 4788 Views | Created by Tariq Hasan - Wednesday, April 15, 2020 2:35 PM | Last reply by Tariq Hasan - Saturday, April 18, 2020 4:43 PM -
0 Votes
cmd is not accepting yes or no
before this is not happen it wait until i type yes or no then further print this C:\wamp64\www\basic> in simple words ...Unanswered | 3 Replies | 4026 Views | Created by fejanmalek - Friday, April 17, 2020 5:21 AM | Last reply by Erland Sommarskog - Friday, April 17, 2020 9:23 PM -
0 Votes
Reading Data
Hi, i am writing a stored procedure something like Select *,TotalRows = COUNT(*) OVER() from MyTable where .... I am able to read the data but unable to get the Total ...Unanswered | 1 Replies | 3854 Views | Created by slalithp - Monday, April 6, 2020 8:06 AM | Last reply by nielsb - Tuesday, April 7, 2020 4:18 AM - Items 1 to 20 of 2949 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.