The use of “Auto Increment Identitiy Column” in tables is common. In some cases, we may want to find the last Identitiy value generated. …
Read More »MSSQL
Cannot drop database because it is currently in use
If you want to delete the database, you will get this error if there is an open session on the database. First, set the …
Read More »DATALENGTH Function in SQL Server(TSQL)
With the DATALENGTH function, we can calculate the size of the data in a column in bytes. Usually, its useful for calculating the size of …
Read More »No global profile is configured. Specify a profile name in the @profile_name parameter
With Database Mail, you can get this error when you want to send mail using msdb.dbo.sp_send_dbmail. This is because none of the Database Mail …
Read More »@@SPID Function in SQL Server(TSQL)
With the @@ SPID Function, we can find the session id of the current session. Usually we use when we want to exclude the …
Read More »How To Find Total Size of All Databases in All Instance
Finding the total size of all your databases may be a bit difficult when your number of instances and your database count increases. Sometimes …
Read More »SQL Server Logon Trigger
Hello there, User management is very important in our database systems. We prefer DBAs to create or use more windows authentication instead of sql authentication. …
Read More »SQL Server Cursor
Hello there, A query operation is performed on SQL Server. If the cursor is on the line, the data in that line is processed. DML …
Read More »@@SERVICENAME Function in SQL Server(TSQL)
You can find the name of the SQL Server Instance that you are connected to with the @@ SERVICENAME Function. If the instance you …
Read More »Set RegisterAllProvidersIP Value to 0 as Based on Availability Group
If you ran a validation report on the windows, a warning might appear. “The RegisterAllProvidersIP property for network name ‘Name: ‘ is set to 1. …
Read More »