I was working on one the project and they were looking for a backup report which should specify whether it’s physical or logical and few more details. Whatever data I fetched looks good and I felt the same can be helpful for you guys to pull it as a report. If you need any more additions to it please let me know. Continue reading Backup Report
Category Archives: Scripts
Identify Orphan Users in All the databases
There are lot of scripts available in the internet to find orphan users across the database.
This will be my version fo script to find out orphan users in all the databases excluding system databases. Continue reading Identify Orphan Users in All the databases
Identify Null Columns and Data Null Columns
I saw an interesting question in Facebook group. It’s all related to NULL values.. How to identify NULLable columns in a table and column with data as NULL. I thought of searching it in internet and pointing him to the link but I couldn’t get a reliable post to point it to the user so I finally wrote it. This script will just give you information about nullable columns in a table and whether the nullable column has null values. You can either scan NULL data or you can skip it. Continue reading Identify Null Columns and Data Null Columns
Generate Users and Roles Script
Couple of weeks back I wrote a script for generate object level permission in the database. People started requesting me to write a script which should script all the users and roles in a database. I came up with this script which will script roles and users in a database and it will also associate user with their roles.
T-SQL Script to find the names of the StoredProcedure that has used dynamic SQL
This article has the script that will be useful to find the names of the Stored procedure that has used dynamic sql within the definition of the Stored procedure .
In this post , I am creating a sample database with four stored procedures to show an example on how the script works : Continue reading T-SQL Script to find the names of the StoredProcedure that has used dynamic SQL