Fix SQL Server Error 15138: Dropping User that owned Schema & Error 3729: Schema that referenced to the object
Here we will learn how to fix Microsoft SQL Server error 15138 & error 3729 that we receive while dropping…
8 years ago
Troubleshooting
Fix SQL Server Error 15173: Revoke the permission(s) before dropping the login.
A login was failed to drop from a SQL Server instance with an error code 15173. As Microsoft SQL Server…
8 years ago
Fix SQL Server Error 15174: Login owns one or more database(s). Change the owner of database(s) before dropping the login.
I came across Microsoft SQL Server error 15174 while dropping a login. As error suggests, the login which i want…
8 years ago
Why is Secondary Replica Showing in Resolving state after AOAG Automatic failover?
Sometimes AOAG configuration stuck in resolving state and its secondary Replica does not come online. When you check the Alwayson…
8 years ago
SQL Server Error 233: User Connections Server Configuration option in SQL Server
Today, I got a requirement to limit the number of concurrent user connections on a SQL Server Instance. SQL Server…
8 years ago
How to Recover or Repair Suspect Database in SQL Server
Suspect database in SQL Server is not very common issue but there are times we face it because of various…
14 years ago
Error 14258: Cannot perform this operation while SQL Server Agent is starting. Try again later
I saw SQL Server error 14258 today while i was diagnosing my log shipping issue in which primary and standby…
14 years ago
Fix: Msg 7321, Level 16, State 2, Line 1 An error occurred while preparing a query for execution against OLE DB provider ‘ADsDSOObject’. OLE DB error trace [OLE/DB Provider ‘ADsDSOObject’ ICommandPrepare::Prepare returned 0x80040e14].
Whenever you get the issue "Msg 7321" make sure your security context is correctly supplied. Otherwise you will get below…
14 years ago
How to find Total no of Traces Running on your Database Instance?
Suppose you want to find out how many traces are running on your SQL Server database instance? If you don't…
14 years ago
Error Msg 1813, Level 16, State 2, Line 1, Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted.
The error 1813 comes when corrupt transaction log are attempted to attach to new server. Error details are given below:…
14 years ago