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…
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…
[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!
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 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…
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.
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 …
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…
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.
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…
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…
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 Replication with error
Error "Agent message code 20084. The process could not connect to Distributor " in distributor agent, how do I fix this
ResourceDB
If we move master database to a new location, does the ResourceDB database also move?
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.
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 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…
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 agent job fail
The error message is An idle CPU condition has not been defined
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…