Configure SQL Server DBMAIL using T-SQL
Configuring dBMail involves 3 main steps Step 1: Creating Mail Profile Step2: Creating Mail Account Step3: Mapping Account to Profile. Below
Category: DBA SCRIPTS
How to list SQL Server Service Accounts using T-Sql?
There might be times for audit to list all the service accounts from all SQL Servers, In order get this
How to run a SQL Query on list of servers and save output to excel using power shell?
You will see how much is powershell is useful for DBA after using this script. Step 1: Create a text
HOW TO VERIFY IF A BACKUP FILE IS CORRUPTED?
There are times when we do a backup as a DBA, we come across problems when we restore the backup
HOW TO CHECK IF A USER ACCOUNT IS LOCKED? IF LOCKED HOW TO UNLOCK IT?
There are times a DBA gets a request to see the user account got locked or the user is unable
How to transfer logins and passwords between instances of SQL Server?
There are many ways to transfer logins between instances under the same domain like 1. Scripting out logins 2. Logins
script to merge column rows to single row seperated by comma,
Using STUFF function in sql serevr a column values can be retrieved as single value row, values seperated by comma’s.
