17,805 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Upgrade SQL server 2014 to 2019 after lift and shift to Azure

Hi, We are planning to do in-place upgrade SQL server from 2014 to 2019. The server is lift and shifted to Azure so is updating the server same as updating on premise server or is there anything different. please provide suggestions. Thank you

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,607 questions
asked 2024-04-16T17:01:10.83+00:00
Newtojob 6 Reputation points
answered 2024-04-16T17:19:23.1866667+00:00
Liakesala salek 0 Reputation points
1 answer

VB.NET SQL Connection and SQL Command Error BC3002

Hello, I'm in the process of converting VBA to VB.NET with SQL statements. One of the changes is utilizing the "ExecuteNonQuery". Since I'm still learning the syntax, I simply copied the VB.NET statements from a web-site. But I'm getting 2…

VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,559 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
38 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,546 questions
asked 2024-04-16T16:02:09.4533333+00:00
Giacomo Raucci 296 Reputation points
answered 2024-04-16T17:10:01.7633333+00:00
Viorel 111.6K Reputation points
2 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,607 questions
asked 2024-04-15T20:47:18.0366667+00:00
Ryan Schmitz 0 Reputation points
answered 2024-04-16T15:45:07.11+00:00
Ryan Schmitz 0 Reputation points
3 answers

SQL SERVER 2022 - certificate error when creating a job for integration services

In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…

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,607 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
asked 2024-04-10T03:35:21.82+00:00
Marcio Matos 0 Reputation points
answered 2024-04-16T15:09:40.3633333+00:00
MJ 0 Reputation points
2 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,607 questions
asked 2024-04-16T14:09:24.11+00:00
Chaitanya Kiran 676 Reputation points
answered 2024-04-16T14:59:53.0866667+00:00
Olaf Helper 40,576 Reputation points
2 answers

Retrieving the COM class factory for component with CLSID {00000000-0000-0000-0000-000000000000} failed due to the following error: 80040154

I have a simple PowerShell script as below  $excel = new-object -ComObject excel.application  $filePath = 'filename.xlsm'  $wb = $excel.workbooks.open($filePath)  $excel.Run('Macro')  $excel.quit()  Stop-Process -Name "Excel" When I trigger the…

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,607 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,453 questions
asked 2024-04-14T20:25:01.46+00:00
sandeep singamaneni 0 Reputation points
commented 2024-04-16T14:18:54.7566667+00:00
sandeep singamaneni 0 Reputation points
3 answers

Restore-SqlDatabase (poweshell cmd) skip the statment which execute from SQL Server Agent job

Hi I am rewriting a powershell script to refresh the non production env from production env. its working fine while executing from powershell prompt. But when I executed same script from Sql server Agent job. Job is successfully complete . But DB restore…

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,607 questions
asked 2021-01-12T01:29:27.46+00:00
Ashwan 521 Reputation points
answered 2024-04-16T14:12:57.01+00:00
Kolodziej Maciej 0 Reputation points
7 answers

Hide SQL DB's Users do Not have Access to

I know I can set the permission to Deny "View all DB's" but I need users who are mapped to their DB's to be able to see them in SSMS. Thoughts?

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,607 questions
asked 2024-04-10T15:43:00.6166667+00:00
rr-4098 1,086 Reputation points
commented 2024-04-16T14:01:10.01+00:00
rr-4098 1,086 Reputation points
1 answer

Migration of On-Prem SQL Servers to Azure

Hello, I have 2 On-prem SQL Servers (One is primary server and other is Secondary server). SQL version is 2016 and edition is Enterprise. I have configured always-on for 10 big databases under multiple AAGs. Now I want to migrate my both On-Prem SQL…

Azure Database Migration service
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,607 questions
asked 2024-04-16T09:02:02+00:00
Parth Mehta 0 Reputation points
answered 2024-04-16T12:18:27.94+00:00
Sreeju Nair 11,601 Reputation points
7 answers

Fixing Error 0: No process is on the other end of the pipe.

Recently trying to work on some SSRS stuff with a local instance of my company Database, and I messed with number of allowed connections. Now attempting to connect to my local instance yields: Microsoft SQL Server Management Studio Cannot show requested…

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,607 questions
asked 2020-08-18T16:55:09.007+00:00
Zac Watkins 6 Reputation points
commented 2024-04-16T11:24:06.7333333+00:00
eqsoft 0 Reputation points
3 answers One of the answers was accepted by the question author.

SSMS 20 can't show conflict viewer

Hi! Clicking on View conflicts in Object Explorer open Connect to Server dialog form instead of Conflict Viewer. If I fill in form to connect to the same server, it creates very strange error: A connection was successfully established with the server,…

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,607 questions
asked 2024-04-05T12:35:44.52+00:00
Nebojsa Ilic 15 Reputation points
accepted 2024-04-16T10:42:59.6833333+00:00
Nebojsa Ilic 15 Reputation points
1 answer

"Could not find the Database Engine startup handle" while trying to install SQL server 2022 Express Edition

Hello, I upgraded my computer to Windows 11 and that's why there was a problem in my SQL server. I deleted the SQL Server 2022 application and restarted the computer. Later, I encountered an error while trying to install SQL Server 2022 Express. Unable…

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,607 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,449 questions
Microsoft Configuration Manager
asked 2024-04-12T12:42:24.9666667+00:00
Hakan KARATEKE 0 Reputation points
commented 2024-04-16T09:59:21.8766667+00:00
Hakan KARATEKE 0 Reputation points
1 answer

EvntAgnt event error 3007

Hi Support, Our SQL server have an error 3007 on the EvntAgnt: Error opening event Error opening event log file State. Log will not be processed. Return code from OpenEventLog is 87. Any idea?

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,607 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,055 questions
asked 2024-04-08T04:22:41.3733333+00:00
Chong 841 Reputation points
commented 2024-04-16T09:45:28.9466667+00:00
LucyChen-MSFT 405 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,607 questions
asked 2024-04-04T12:27:47.1733333+00:00
Gaurav Thakare 0 Reputation points
commented 2024-04-16T09:42:01.7866667+00:00
LucyChen-MSFT 405 Reputation points Microsoft Vendor
1 answer

MSSQL SMS export error

We are working on automation through AutoHotkey. When selecting the data source when exporting from MSSQL SMS, if you select SQL SERVER NATIVE CLIENT 11.0 with the mouse, the export to Excel, etc. works fine without any problem. If you pass the FLAT FILE…

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,607 questions
asked 2024-04-03T01:48:51.9266667+00:00
윤석 차 0 Reputation points
commented 2024-04-16T09:40:48.7333333+00:00
LucyChen-MSFT 405 Reputation points Microsoft Vendor
2 answers

How to solve secondary availability group is an unhealthy status in SQL server distributed availability group?

Hello, I would like to help one thing that is my SQL server issue. When I create distributed availability group, secondary available group is show an unhealthy status in SQL server Clustering. Please see the below photo. I already alter in secondary AG…

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,607 questions
asked 2024-04-01T16:08:31.54+00:00
Paing Hein Kyaw 40 Reputation points
commented 2024-04-16T09:39:29.8466667+00:00
LucyChen-MSFT 405 Reputation points Microsoft Vendor
1 answer

Nightly snapshot causing SQL Server backups to break in Veritas NetBackup chain

We are experiencing issues with the backup chain being interrupted by a VM snapshot backup. Our regular SQL backups are sent to NetBackup, and we want to maintain the backup/restore chain within NetBackup without the need to interrupt it with a snapshot…

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,607 questions
asked 2024-04-01T02:13:44.51+00:00
Vanitha Dodla (MINDTREE LIMITED) 40 Reputation points Microsoft Vendor
commented 2024-04-16T09:38:21.0833333+00:00
LucyChen-MSFT 405 Reputation points Microsoft Vendor
2 answers

SQL 2017 - Granting unmask access to security group not working getting errors

Hi All, I am trying to grant unmask access for a security group for a specific table and for a specific column however im getting a the below error message. query executed. GRANT UNMASK ON schemaName.tablename(ColumnName) TO [Account that requires…

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,607 questions
asked 2024-04-15T15:38:23.29+00:00
Kevin 0 Reputation points
edited a comment 2024-04-16T09:31:01.44+00:00
MikeyQiao-MSFT 325 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to Get Description of Column_Flags by function GetSchema

hi . What are these numbers and how can they be translated? Dim cn As New OleDb.OleDbConnection(Conn_String_Access) cn.Open() Dim dtSheama As New DataTable dtSheama = cn.GetSchema("Tables") 'indexes'columns'Tables

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,607 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,559 questions
asked 2024-04-15T17:21:22.44+00:00
Mansour_Dalir 1,431 Reputation points
accepted 2024-04-16T09:11:04.1433333+00:00
Mansour_Dalir 1,431 Reputation points
1 answer

extend Azure SQL always on availability group to on prem

I have an Azure SQL always on availability group with 2 servers, i need to add another on-prem node to the AG. Azure SQL AG deployed in a single subnet with DNN listener, and i already have S2S connectivity between Azure and on-prem. do i have to migrate…

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,607 questions
asked 2024-04-15T13:47:40.6133333+00:00
Abdalrahman Allahham 20 Reputation points
edited the question 2024-04-16T09:05:04.1466667+00:00
ZoeHui-MSFT 32,411 Reputation points