SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
1 answer
VBscript not running on windows server 2019
Hi All, Our VB Script has been integrated with SSIS package as script task and it work in fine in visual studio IDE . However, it is getting failed to run same VB script block in windows server 2019 environment inside SSISB as a SSIS Package. Please…
SQL Server
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,722 questions
2 answers
Retrieve an SQL standard license for in place upgrade
We are running a SQL virtual machine SQL server under a developer license that needs to be upgraded to a standard SQL license. The payment for the SQL license is done through Azure so no license keys in our control. Now with the upgrade through the…
asked 2023-10-26T06:57:14.84+00:00
bauke
5
Reputation points
commented 2024-10-02T05:09:37.73+00:00
Ben Miller-(DBADuck)
110
Reputation points MVP
1 answer
TFS: Checking in SSIS Packages and removing credentials
Our team use TFS for source control, for various objects, including SSIS packages. Those SSIS packages will often contain personally-issued credentials used for configured DB connections, etc. which (at least) the UserId is saved, if not the password.…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-10-01T18:57:30.8066667+00:00
Tony Scott
0
Reputation points
answered 2024-10-02T05:07:25.33+00:00
Olaf Helper
44,501
Reputation points
2 answers
sp_send_dbmail do not send query result on body when executed in contained Availability group
msdb.dbo.sp_send_dbmail does not send the query resut when executed in the contained availability group." When the same query is executed on the principal instance, the email was sent correctly: EXEC msdb.dbo.sp_send_dbmail …
asked 2024-09-30T15:39:15.37+00:00
Giorgio
0
Reputation points
commented 2024-10-02T04:17:14.8533333+00:00
Ben Miller-(DBADuck)
110
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')
Hi, I am encountering an issue while trying to connect to an SQL database using a Python script in my Jupyter notebook. The connection attempt results in the following error message: OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 17 for SQL…
0 answers
CSP header
We are using SSRS via the standard Web Portal URL. The security department is particular about the CSP header. What is the minimum CSP SSRS Web Portal needs to have? Can we remove 'unsafe-inline' 'unsafe-eval' from the CSP header?
asked 2024-10-02T03:12:07.7533333+00:00
work account 1
0
Reputation points
asked 2024-10-02T03:12:07.7533333+00:00
work account 1
0
Reputation points
2 answers
Is it good to use single database connection for all database operations in one API request?
In general, I know the best practice while handling database connections in C#/ADO.NET is to open Db connection just before querying the Db & close the connection immediately after query execution, so that connection gets back to pool. My question…
asked 2024-09-30T18:48:01.8833333+00:00
Abhilash Perla
0
Reputation points
commented 2024-10-02T02:33:40.3166667+00:00
LiHongMSFT-4306
27,016
Reputation points
1 answer
TLS 1.0 and TLS 1.1 deprecation ,Will it Stop Azure VM internal servers communication
Hi, We have two servers running on Azure. Both servers are running on Windows Server 2008 R2. One server is configured as an IIS server, and the other is a legacy SQL Server. Both servers communicate with each other using TLS 1.0 and 1.1. My question is:…
asked 2024-10-01T11:12:34.7633333+00:00
Rashid Ahmed Qazi
20
Reputation points
answered 2024-10-02T01:40:51.0133333+00:00
Lex Li (Microsoft)
5,582
Reputation points Microsoft Employee
1 answer
Setting up multiple instance read-only routing
Hi All, I have googled this but unfortunately could not find any answer because everyone has a document that shows only 1 AG/Instance example and none for multiple instances/AG groups an a same server. I have 3 instances on one server (Always On with 2…
asked 2024-09-30T16:52:06.4433333+00:00
Carlos D
51
Reputation points
commented 2024-10-02T00:57:04.8866667+00:00
ZoeHui-MSFT
36,511
Reputation points
1 answer
One of the answers was accepted by the question author.
Max value of each column in a table
Hi there, I have 500+ Azure SQL tables with total of 25000+ columns. Most of the tables have varchar (max), or nvarchar(max) but to contain a value which could only be 3 , 5 or 20 characters long. --for characters select max(**len(**columnname)) from…
1 answer
One of the answers was accepted by the question author.
System.ArgumentException: 'Keyword not supported: 'trust server certificate'.'
When I try to add new data into the SQL table I get this error message. System.ArgumentException: 'Keyword not supported: 'trust server certificate'.' SqlConnection con = new SqlConnection("Data Source=JERRY-P720\JW_SQLEXPRESS;Initial…
1 answer
Error creating SQL user accounts from external provider with Azure Arc
When trying to create user accounts that use Azure login in Azure Arc, we receive the error shown in the user's image. How can we resolve this issue?
asked 2024-05-03T12:16:54.9066667+00:00
AJ Copeland
5
Reputation points
commented 2024-10-01T21:12:04.3633333+00:00
Erland Sommarskog
111.1K
Reputation points MVP
4 answers
Issue with sending emails from contained availability group SQL 2022
Hi, We're having issues with sending out emails from the contained availability group in SQL 2022 The setup consists of 3 servers 2 sync and 1 async. All accounts/profiles are setup on availability group and also all the individual servers (which i…
asked 2023-04-20T12:37:20.2533333+00:00
Audrius Zepkinas
0
Reputation points
answered 2024-10-01T21:09:22.87+00:00
Ben Miller-(DBADuck)
110
Reputation points MVP
0 answers
SSMA for Oracle error ROW-00001 Unable to Allocate Memory
Hi, I am migrating from Oracle to Azure SQL Server Managed Instance. Some of my tables have 100+ million rows so I have partitioned those tables in the source Oracle database so I am only migrating smaller tables to Managed Instance (typically between 3M…
asked 2024-09-26T17:38:21.1166667+00:00
Vincent Molloy
0
Reputation points
commented 2024-10-01T18:07:53.1633333+00:00
NIKHILA NETHIKUNTA
2,395
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Is my Resource Governor set up correctly?
Greetings. I have a particular server configured as follows: DB1 -- this guy is the Subscriber of a transaction replication topology. DB2 -- this guy is a Data Warehouse (using that term loosely). If queries data from DB1, as well as other sources…
1 answer
EF Core 8 Shadow Properties incur a 255 limit on columns
We have an EF based WebApi, and the business logic includes the ability for end users to add user defined fields To get that in EF, we engaged Shadow Properties, and that is working well Unfortunately we found Shadow Properties incur a limit of 255…
asked 2024-10-01T15:21:02.83+00:00
Bill Stamp
1
Reputation point
edited an answer 2024-10-01T15:34:04.55+00:00
Bruce (SqlWork.com)
64,901
Reputation points
1 answer
SQL Server on Azure VM Backup minimizing data duplication
A while back, a Microsoft support engineer recommended using SQL on VM backups. The suggestion was to create an SQL DB in an Azure VM job and an Azure VM job, excluding the disks that host the SQL files, to avoid data duplication. If the VM is deleted…
asked 2024-09-29T01:18:07.9433333+00:00
Josue Del Valle
20
Reputation points
commented 2024-10-01T15:11:50.9566667+00:00
Sai Raghunadh M
310
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
better query for select results based on date.
What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…
asked 2024-09-30T19:03:37.35+00:00
Jonathan Brotto
420
Reputation points
accepted 2024-10-01T14:47:10.7333333+00:00
Jonathan Brotto
420
Reputation points
1 answer
One of the answers was accepted by the question author.
better query for select results based on date.
What is the best way to write this code to get the date results? I have the time throughout the day in the datetime field. SELECT * FROM Reconciliation.Documents D Inner Join Reconciliation.DocumentsTransaction T ON D.DocumentPKey = T.DocumentPKey WHERE…
asked 2024-09-30T19:03:37.35+00:00
Jonathan Brotto
420
Reputation points
accepted 2024-10-01T14:47:10.7333333+00:00
Jonathan Brotto
420
Reputation points
2 answers
sql server install not properly
TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: SQL Server Setup has encountered an error when running a Windows Installer file. Windows Installer error message: An error occurred during the installation of assembly…
asked 2024-07-04T04:46:59.23+00:00
Ashutosh Olekar
0
Reputation points
answered 2024-10-01T13:46:26.4666667+00:00
_cypheX
0
Reputation points