17,669 questions with SQL Server-related tags

Sort by: Updated
1 answer

Determine SQL Licensing Type after installation

Hello, From the Microsoft Volume Licensing Center, I downloaded both Server/Cal and PerCore SQL Server 2022 Standard Edition download (ISO) files and placed them in separate folders, not realizing they were saved with the same name. A coworker installed…

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,484 questions
asked 2024-03-28T15:59:59.69+00:00
Bela de Souza 0 Reputation points
answered 2024-03-28T22:12:10.8766667+00:00
Erland Sommarskog 100.1K Reputation points MVP
1 answer

Need to create Powershell report for SQL Always on secondary serves.

Hello All, A strange request. We are running multiple always on servers. Backups takes place on secondary replica of always on server. I need to create a report in powershell or t-sql that would identify secondary replica and verify backup…

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,484 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,322 questions
asked 2024-03-28T19:56:55.6533333+00:00
Parag Kambli 0 Reputation points
answered 2024-03-28T22:06:13.8433333+00:00
Erland Sommarskog 100.1K Reputation points MVP
4 answers One of the answers was accepted by the question author.

[Question] ODBC Read/Write Permission - Can Create a Stored Procedure?

I am not an SQL/Database Expert, but I would like to know more and am curious if a user with an ODBC Read/Write Access to the database. Can it create/alter stored procedures? Thanks a lot!

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,484 questions
asked 2024-03-27T03:40:17.98+00:00
homerm 60 Reputation points
answered 2024-03-28T21:59:57.08+00:00
Erland Sommarskog 100.1K Reputation points MVP
2 answers

How to fix an error when installing MS SQL

Hello, I was trying to install MS SQL on my computer but unfortunately i keep getting error with database engine startup handle. I tried to find answers for hours in various forums but nothing I found worked. Below I place screenshot together with…

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,484 questions
asked 2024-03-27T21:17:35.4233333+00:00
Oskar Nowak 0 Reputation points
commented 2024-03-28T21:49:54.9733333+00:00
Erland Sommarskog 100.1K Reputation points MVP
3 answers One of the answers was accepted by the question author.

SQL 2022 Bug - FILESTREAM

Trying to setup database with FILESTREAM. Using scripts that work great on previous versions of SQL Server (2016 to 2019). Getting strange error message when trying to add file to filegroup: Msg 35221, Level 16, State 1, Line 2 Could not process…

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,484 questions
asked 2022-12-15T20:37:53.993+00:00
Clarke, Ron 21 Reputation points
commented 2024-03-28T21:44:50.8166667+00:00
Erland Sommarskog 100.1K Reputation points MVP
1 answer

In SSRS 2019 Can you change the background color of the Parameters pane?

In SSRS 2019 Can you change the background color of the Parameters pane? It is defaulted to white. I have been unable to find anything about it in the Branding or the SSRS Report Builder information.

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,772 questions
asked 2024-03-28T13:25:01.0966667+00:00
Newman, Michael 0 Reputation points
commented 2024-03-28T21:43:21.2466667+00:00
Michael Taylor 45,996 Reputation points
1 answer

How to loop through multiple Sql Server instance, database, and table/view names?

It's been a long time since I write any C# code. I'm trying to query some tables and views from different SQL Server instance, database names, and tables/views. Below is my sample code. public void Main() {             // TODO: Add your code here        …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,098 questions
asked 2024-03-28T14:57:55.1266667+00:00
CharlieLor 551 Reputation points
commented 2024-03-28T18:48:41.6433333+00:00
Michael Taylor 45,996 Reputation points
2 answers

What Is the Best Way to See Raw Data Stream Being Passed from SQL to .NET Application?

I am running some functions on application startup for my .NET application. This mostly involves running a bunch of scripts on my SQL database to ensure plans are cached. These queries are generated from EFCore-compiled queries. In doing this, I…

Azure SQL Database
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,264 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,078 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,484 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,689 questions
asked 2024-03-14T19:52:31.8+00:00
Mike-E-angelo 441 Reputation points
commented 2024-03-28T16:15:12.0766667+00:00
Bruce (SqlWork.com) 53,426 Reputation points
0 answers

EnableCrossDatabaseFolding for SSAS?

Is there any chance this option will be added also to SSAS? I'd like to no longer have to define views just to fake using only one database.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,240 questions
asked 2024-03-28T14:46:08.6566667+00:00
Salvatore Iamundo 0 Reputation points
2 answers

How to troubleshoot "Read-SqlTableData : Failed to connect to server" error?

I have this PoweShell script code: $sqlView = Read-SqlTableData -ServerInstance $query.Instance -DatabaseName $query.DB -SchemaName $query.Schema -TableName $query.View I keep getting this error: Read-SqlTableData : Failed to connect to 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,484 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,322 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
1,964 questions
asked 2024-03-22T15:58:51.97+00:00
CharlieLor 551 Reputation points
answered 2024-03-28T14:35:34.31+00:00
CharlieLor 551 Reputation points
1 answer

SSIS Send Mail Task Fails on Out of office

I have a simple Send Mail Task that sends an email to a list of dynamic users. If one of those users has "out of office" set, the SSIS flow fails. The next day, when it sends again, it works, because "out of office" doesnt respond…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 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.
485 questions
asked 2024-03-25T13:11:29.8966667+00:00
Mark Lewin 0 Reputation points
commented 2024-03-28T13:35:58.5233333+00:00
Mark Lewin 0 Reputation points
1 answer

DATEDIFF (YEAR, StartDate, EndDate) returns incorrectly

I am trying to figure out why the DATEDIFF(YEAR) Function is returning incorrectly and am wondering if I have to get the StartDate and EndDate in a certain format before attempting to use the function. SELECT DATEDIFF(YEAR, '2023-12-31 08:31:42.373',…

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.
31 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,536 questions
asked 2024-03-28T13:03:43.4066667+00:00
Bobby P 221 Reputation points
answered 2024-03-28T13:20:03.25+00:00
Olaf Helper 40,156 Reputation points
0 answers

SQL Replication with error

Error "Agent message code 20084. The process could not connect to Distributor " in distributor agent, how do I fix this

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,484 questions
asked 2024-03-28T09:25:51.2366667+00:00
Andrew Lamb 0 Reputation points
edited a comment 2024-03-28T12:57:11.26+00:00
Andrew Lamb 0 Reputation points
0 answers

ResourceDB

If we move master database to a new location, does the ResourceDB database also move?

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,484 questions
asked 2024-03-28T12:55:56.9433333+00:00
Chaitanya Kiran 656 Reputation points
3 answers

Using MS SQL 2019 on Windows Server 2022 Essentials

Is it possible to use MS SQL 2019 on Windows Server 2022 Essentials? WS22 Essentials is not listed between the supported OS, but the same situation was with MS SQL 2016 and OS Essentials support appeared afterwards.

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,484 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,931 questions
asked 2022-06-17T09:13:26.82+00:00
Jirka505 1 Reputation point
answered 2024-03-28T12:40:59.8266667+00:00
Tomas Kallus 0 Reputation points
2 answers

Replication Reinitialization from backup

I have Reinitialization transactional replication of 950 GB database from backup. It is working fine. I left allow_anonymous & immediate_sync 1 i.e true. I plan to keep it as true. Is that fine or do I need to change to false. I have tried to put…

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,484 questions
asked 2024-03-26T12:16:08.5233333+00:00
Saran 26 Reputation points
answered 2024-03-28T12:25:24.13+00:00
Saran 26 Reputation points
1 answer

SQL Express

I have a computer connected to internet to perform downloads. I have another computer on a lan that I can't connect to the internet. I want to upgrade my sql express from 2012 or 2022. Where can I get the complete file from and not an installer that goes…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,418 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,484 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,931 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
7,921 questions
asked 2024-03-28T10:14:21.2066667+00:00
Michael DragoneFire 0 Reputation points
edited the question 2024-03-28T11:12:45.09+00:00
ShaktiSingh-MSFT 12,941 Reputation points Microsoft Employee
1 answer

Master Data Service installation issue

When I install MDS 2022 Excel Add-In, there is an error message saying it can't find pre-requirement SQL Server 2010. When I search for the SQL Server 2010 run time, it is no longer available. What can I do to install MDS completely?

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,484 questions
asked 2024-03-26T05:45:53.81+00:00
Yan Xie 0 Reputation points Microsoft Employee
answered 2024-03-28T10:13:31.42+00:00
MikeyQiao-MSFT 0 Reputation points Microsoft Vendor
1 answer

Sql server agent job fail

The error message is An idle CPU condition has not been defined

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 questions
asked 2024-03-28T09:38:38.8666667+00:00
Jefferson 386 Reputation points
answered 2024-03-28T09:59:01.45+00:00
Olaf Helper 40,156 Reputation points
0 answers

Suitable backup location for the Certificate and DEK backup for a database with Transparent Data Encryption Enabled on SQL Server

I have SQL instances that will have TDE enabled soon and I need a backup option for the Certificate and DEK after the database has been encrypted, I don't want to have the files on the same location where the databases are hosted so I thought key vault…

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,083 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,484 questions
asked 2024-03-28T09:47:34.0066667+00:00
Themba Phiri 0 Reputation points