17,670 questions with SQL Server-related tags

Sort by: Updated
0 answers

I want to mask all user privilege both Admin or owner cannot view mask table.

Dear Sir/Madam https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver16 Refer to link Official Microsoft above, Administrative users or roles such as sysadmin, serveradmin, or db_owner have CONTROL…

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,486 questions
asked 2024-03-29T03:42:42.18+00:00
Srean Noem 20 Reputation points
2 answers One of the answers was accepted by the question author.

Could drop user sa?

Dear Sir/Madam As we know user sa is default user that have sid=0x01 is_disabled=0 principal_id=1 on sys.server_principals table. Could we drop it to protect from attacker? Srean Regard Thank

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
asked 2024-03-07T04:53:58.0233333+00:00
Srean Noem 20 Reputation points
accepted 2024-03-29T03:30:29.4466667+00:00
Srean Noem 20 Reputation points
1 answer

Failed to connect to DESKTOP-35COSO3\MSSQLSERVER03:1433 - self-signed certificate

Get this error while connecting my node js to MSSQL server. PS C:\Users\ANJALI\Documents\Curate\Website\Backend> node index.js ConnectionError: Failed to connect to DESKTOP-35COSO3\MSSQLSERVER03:1433 - self-signed certificate at…

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,486 questions
asked 2024-03-28T09:37:41.9633333+00:00
Anjali Kumawat 20 Reputation points
answered 2024-03-29T03:13:09.6766667+00:00
CosmogHong-MSFT 21,851 Reputation points Microsoft Vendor
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,486 questions
asked 2024-03-28T09:47:34.0066667+00:00
Themba Phiri 0 Reputation points
commented 2024-03-29T02:58:22.2+00:00
CosmogHong-MSFT 21,851 Reputation points Microsoft Vendor
3 answers

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,486 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.
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-29T02:13:05.4266667+00:00
CosmogHong-MSFT 21,851 Reputation points Microsoft Vendor
2 answers

Does ms sqlserver support JWT or client certificate authentication

We are using JDBC and ODBC to connection MS SQL Server authenticated by user name and password, but from security requirement we need to find a more secure client authentication method. Does SQL Server support client certificate or JWT client…

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,486 questions
asked 2024-03-25T09:57:05.8633333+00:00
Gong, Allen 0 Reputation points
answered 2024-03-29T02:00:33.6366667+00:00
Gong, Allen 0 Reputation points
2 answers

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-29T01:57:25.89+00:00
ZoeHui-MSFT 32,081 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,486 questions
asked 2024-03-26T12:16:08.5233333+00:00
Saran 26 Reputation points
commented 2024-03-29T01:47:16.8366667+00:00
MikeyQiao-MSFT 0 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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 20 Reputation points
accepted 2024-03-28T23:07:17.35+00:00
Newman, Michael 20 Reputation points
3 answers

sys.dm_os_performance_counters to collect cpu usage

Hello everyone, I use sys.dm_os_performance_counters to collect cpu usage for SQL Server 2016 SP3, but the values are always 0. Is it normal? Thanks,

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,486 questions
asked 2022-02-24T22:23:31.99+00:00
Igor Gelin 21 Reputation points
answered 2024-03-28T22:28:23.8033333+00:00
Krishna Singh 0 Reputation points
1 answer

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,486 questions
asked 2024-03-28T12:55:56.9433333+00:00
Chaitanya Kiran 656 Reputation points
answered 2024-03-28T22:19:04.5533333+00:00
Erland Sommarskog 100.1K Reputation points MVP
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,486 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,486 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,486 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,486 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,486 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

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,079 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,486 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,690 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,501 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,486 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