Deploying SharePoint, a client tried to change the dbo mapping and got Msg 15150: Cannot alter the user ‘dbo’. Here is why it happens and how to fix it.
SQL SERVER – Msg 3225: Use of WITH CREDENTIAL Syntax is Not Valid for Credentials Containing a Shared Access Signature
Backup to URL worked, but a maintenance plan failed with Msg 3225: WITH CREDENTIAL is not valid for credentials with a Shared Access Signature. Here is the fix.
SQL SERVER – Fix the Error – Accessing this Server via SQL Management Objects (SMO) or Distributed Management Objects is Currently Not Permitted
After applying STIG to SQL Server 2016, SSMS said accessing this server via SQL Management Objects (SMO) is not permitted. Here is the cause and the fix.
SQL SERVER – Msg 3743: The Database is Enabled for Database Mirroring. Database Mirroring Must be Removed Before you Drop the Database
Msg 3743 says the database is enabled for database mirroring, and mirroring must be removed before you drop it. Here is how my client got past it.
When to Use IDENT_CURRENT? – Interview Question of the Week #150
When should you use IDENT_CURRENT instead of SCOPE_IDENTITY()? A question I heard at the Group By conference, answered with the key difference.
SQL SERVER – Msg 1105 – Could Not Allocate Space for Object Name in Database ‘DB’ Because the ‘PRIMARY’ Filegroup is Full
Msg 1105 says SQL Server could not allocate space for an object because the PRIMARY filegroup is full, even with free disk. Here is how to reproduce and fix it.
How Many Temporary Tables are Created So Far in SQL Server? – Interview Question of the Week #149
How many temporary tables are created so far in SQL Server? No DMV gives this directly, but here is an easy workaround to find the answer.