17,905 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server

In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,362 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T13:45:40.7233333+00:00
ylycfj88 0 Reputation points
answered 2024-04-25T05:15:43.54+00:00
Smaran Thoomu 9,445 Reputation points Microsoft Vendor
1 answer

Using SSDT on a build server

I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,600 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T19:26:26.72+00:00
Mark DeMichele 0 Reputation points
edited an answer 2024-04-25T04:51:16.41+00:00
Tianyu Sun-MSFT 27,266 Reputation points Microsoft Vendor
2 answers

how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T08:07:29.2066667+00:00
sharuk 0 Reputation points
answered 2024-04-25T03:33:14.5733333+00:00
MikeyQiao-MSFT 485 Reputation points Microsoft Vendor
2 answers

Row-level security in SQL server

In this scenario, I seek assistance in implementing row-level permissions for a table named 'user' with columns 'username' and 'role'. The objective is to establish a security model where access to individual rows is controlled based on the role assigned…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T11:39:39.74+00:00
Lộc Nguyễn 0 Reputation points
answered 2024-04-25T03:07:26.93+00:00
CosmogHong-MSFT 22,861 Reputation points Microsoft Vendor
2 answers

VIEW SERVER STATE vs DB role for DMV on master

Hi, I have a logging procedure that reads from the two tables on master: sys.dm_exec_connections sys.dm_exec_sessions I had to assign permissions to a group for correct execution: GRANT VIEW SERVER STATE TO [domain\mygroup]; but I didn't want…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T08:29:59.1+00:00
Alen Cappelletti 891 Reputation points
edited an answer 2024-04-25T03:04:55.8333333+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
1 answer

SQL server backup in a 2019 VM to s3 using backup URL

Hi I have set up a Windows Server 2019 VM with SQL server 2016. I want to take the backup of SQL server in AWS S3. It should have monitoring and auditing capability and cost effective and secure. I have looked at below…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,113 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,362 questions
asked 2024-04-18T04:47:01.0433333+00:00
Pradeep 21 Reputation points
commented 2024-04-25T02:58:23.2+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
3 answers

GDR upgrade path question

I have a SQL Server updated to version 15.0.4326.1, which is on the GDR path but on a GDR + CU version. Can I install the next update on the GDR path to go to version 15.0.2110.4 that is GDR only, or do I have to install the next GDR + CU update?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-15T20:47:18.0366667+00:00
Ryan Schmitz 0 Reputation points
commented 2024-04-25T02:57:29.71+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
3 answers

Tail log backup

Are tail log backups supported only in Full Recovery model?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-16T14:09:24.11+00:00
Chaitanya Kiran 696 Reputation points
commented 2024-04-25T02:56:38.69+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
2 answers

How to Fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

I am doing a Import Data from an Excel spreadsheet to a table. I get the following message : Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. What will resolve this error?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-12T15:06:30.7966667+00:00
Steve Clark 21 Reputation points
commented 2024-04-25T02:55:51.2566667+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
1 answer

Use SSMA for DB2 to Migrate AIX DB2 11.5.9 to SQL Server 2019

Is it possible to use the SSMA tool to migrate an AIX DB2 (Big endian) to Windows SQL Server 2019 (little endian)?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
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.
494 questions
asked 2024-04-09T20:16:55.67+00:00
Robert Carter 0 Reputation points
commented 2024-04-25T02:54:55.83+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
2 answers

TITLE: Microsoft SQL Server 2014 Setup ------------------------------ The following error has occurred: An error occurred during the installation of assembly 'Microsoft.VC80.CRT,version="8.0.50727.6229",publicKeyToken="1fc8b3b9a1e18e3b",processorArchite

i am unable to download it , i am gettimg an error

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-04T12:27:47.1733333+00:00
Gaurav Thakare 0 Reputation points
commented 2024-04-25T02:54:14.07+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
2 answers

SQL 2022 Install Database Engine Services Fail

Hello, I'm trying to install SQL 2022 for a class. Unfortunately, I'm running into an error. I've tried restarting, and I've also uninstalled/re-installed SQL but I get the same error each time. I'm on an M1 Max Macbook Pro running Sonoma 14.4.1. Using…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-23T21:32:46.8266667+00:00
Santiago Williams 0 Reputation points
commented 2024-04-25T02:52:37.57+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
2 answers

Migrate On prem to Azure Sql Managed instance

I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance. I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without…

Azure Database Migration service
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
926 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-23T17:46:35.1533333+00:00
Shreedevi Sendarapatti Ramamoorthy 0 Reputation points
commented 2024-04-25T02:51:35.9433333+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
2 answers

How can we fix OLE Db or ODBC error[datasource.error]microsoft sql:A transport-level error has occurred when receiving results from the server.(provider:TCP provider,error:o an existing connection was forcibly closed by the remote host in azure sql server

How can we fix OLE Db or ODBC error[datasource.error]microsoft sql:A transport-level error has occurred when receiving results from the server.(provider:TCP provider,error:o an existing connection was forcibly closed by the remote host in azure sql…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-23T09:06:54.5333333+00:00
Anandhswarupp 20 Reputation points
commented 2024-04-25T02:50:55.1333333+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
2 answers

Can i use SQL 2022 Express edition in production environment for my small business?

Can i use SQL 2022 Express edition in production environment for my small business?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-22T08:49:44.7+00:00
Amit Prakash Koli 0 Reputation points
commented 2024-04-25T02:49:56.04+00:00
LucyChen-MSFT 885 Reputation points Microsoft Vendor
1 answer

SQL SERVER IMPORT AND EXPORT WIZARD

I clicked on the next button to import my data from excel and it brings me this error message; TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.16.0' provider is not…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T13:50:36.61+00:00
Mariam Wasiu 0 Reputation points
answered 2024-04-25T02:01:30.5466667+00:00
CosmogHong-MSFT 22,861 Reputation points Microsoft Vendor
1 answer

Ubuntu Jammy ODBC DRIVER update error

How do i resolve this error: sudo apt update Get:4 https://packages.microsoft.com/ubuntu/22.04/prod jammy InRelease Err:4 https://packages.microsoft.com/ubuntu/22.04/prod jammy InRelease Clearsigned file isn't valid, got 'NOSPLIT' (does the network…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T11:48:25.9633333+00:00
Dean Marques 0 Reputation points
answered 2024-04-25T02:00:21.4266667+00:00
ZoeHui-MSFT 32,586 Reputation points
2 answers

Syntax to PRINT the row counts using Dynamic SQL?

Hello, what would be the syntax to PRINT the row counts using Dynamic SQL (in my case here need to get the row counts via a Linked Server View) I would like to have this as a step in a SQL Agent job which after it runs it PRINTs the row counts in it's…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T18:57:32.9433333+00:00
techresearch7777777 1,766 Reputation points
answered 2024-04-25T01:45:46.5966667+00:00
CosmogHong-MSFT 22,861 Reputation points Microsoft Vendor
1 answer

Unable to import excel workbook into MSSQ.

I created a localdb through cmd via a youtube tutorial which allowed me to connect. i am in the mssql application and created my first database. I am wanting to import excel workbooks but the wizard is showing the below error message here, i checked…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,456 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-24T12:44:49.56+00:00
Mo 0 Reputation points
answered 2024-04-25T01:34:31.8933333+00:00
ZoeHui-MSFT 32,586 Reputation points
3 answers One of the answers was accepted by the question author.

How to update sequence of person if he has relative

Currently RelativeID is blank in database. Ho I can update the RelativeID from sequence. If any Empid has relative then should update the unique RelativeID starting from 1. If someone has two relative then RelativeID will be 1 and 2. If someone has three…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
asked 2024-04-17T22:26:20.6+00:00
Martin Kevin 241 Reputation points
commented 2024-04-25T00:13:38.1833333+00:00
Martin Kevin 241 Reputation points