How to Create Virtual Machine on your PC?
Are you struggling to setup a server lab for your requirement? We can create multiple systems running with different flavour…
8 years ago
SQL Server
Fix SQL Server Error 15434: Could not drop login ‘Domain\abc’ as the user is currently logged in
Generally, Microsoft SQL Server error 15434 appears during removing a SQL Server login. This error generates when you try to…
8 years ago
Fix SQL Server Error 15141: The server principal owns one or more endpoint(s) and cannot be dropped
I got Microsoft SQL Server error 15141 while removing a SQL Server domain login on one of instance where AlwaysOn…
8 years ago
What is AlwaysOn Availability Group
SQL Server Always On is just a term given by Microsoft for Availability Group & Failover Cluster Instances that are…
8 years ago
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
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
How to Change Network Packet Size in SQL Server?
Have you ever thought how SQL Server controls the size of packets which are send over the network. There is…
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