This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of dents in snow and boot prints leading away to a vermilion sled

Schema Changes History Report: See Who Dropped a Table

November 23, 2018
Pinal Dave
SQL Tips and Tricks
Schema, SQL Reports, SQL Scripts, SQL Server Security

The Schema Changes History report shows who created, altered or dropped a table. This post reads the same default trace with T-SQL, tests it on a table and a database drop, and explains the limits: file rollover and shared logins. It ends with ways to keep the history longer.

Read More
SQL SERVER - You Are Not Logged on as the Database Owner or System Administrator

SQL SERVER – You Are Not Logged on as the Database Owner or System Administrator

November 2, 2018
Pinal Dave
SQL Tips and Tricks
SQL Documentation, SQL Error Messages, SQL Server, SQL Server Security

A developer creating a table in SSMS got a pop-up: You are not logged on as the database owner or system administrator. Here is what the message means.

Read More
An amber warning lamp standing alone on wet concrete in a dark plant room

SQL SERVER – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault

October 16, 2018
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Azure, SQL Scripts, SQL Server, SQL Server Security

Not an Azure Key Vault after all: a Recovery Services vault that would not delete. The AzureRM script is retired, and soft delete waits 14 days.

Read More
Authentication mode SQL Server.

SQL SERVER – How to Change Authentication Mode Using T-SQL Query

October 13, 2018
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security

A software vendor shipped SQL Express with Windows-only login by mistake. Here is how to change the authentication mode to mixed mode with a T-SQL query.

Read More
SQL SERVER - Error: 45207 - SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid

SQL SERVER – Error: 45207 – SQL Server Managed Backup to Microsoft Azure Cannot Configure the Database Because a Container URL was Either not Provided or Invalid

October 4, 2018
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, SQL Server Security

After a cleanup on my Azure SQL VM, I hit Msg 45207: SQL Server Managed Backup to Microsoft Azure cannot configure the database. Here is how I fixed it.

Read More
Database CheckCompletion error.

SQL SERVER – Unable to Attach Database Files – The PageAudit Property is Incorrect – Ransomware Attack

August 29, 2018
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Error Messages, SQL Log, SQL Scripts, SQL Server, SQL Server Security

After a ransomware attack, a client could not attach database files and saw: The PageAudit property is incorrect. Here is what the error means.

Read More
A tractor at a field gate with an empty seat, a hand reaching up for its red steering wheel

SQL SERVER – FIX: Error – The Job Failed. Unable to Determine If The Owner Domain\User of Job Job_Name Has Server Access

August 20, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

A SQL Agent job failed with: The job failed. Unable to determine if the owner of the job has server access. Here is how I fixed this error in my lab.

Read More
Previous 1 … 10 11 12 13 14 15 16 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com