SQL Server DBA Notes
Tuesday, 20 August 2019
SQL Server : Multiple scripts execution script
›
Following script will help to execute multiple scripts and save output too. We can save our time of manual execution if we need to do hundr...
SQL Server : Query for Scripting out multiple procs
›
use Myproctest_DB go Begin Set nocount on /***********************************************/ /*Mention proc names In first Select State...
MS Excel : Add quotes to Your Cells in Excel Automatically
›
How to Add Quotes to Your Cells in Excel Automatically This tip is going to be mostly helpful to people who working with databases. ...
Monday, 29 July 2019
SQL Server : Check Linked servers pointing to Primary or Secondary
›
-- Script to check Linked servers pointing to Primary or Secondary Declare @lsrv_name sysname declare @exctbl varchar(500); ...
SQL Server : Guest user status on all databases
›
Below script will only list the DB's where guest user is enabled. create table #guest_users ( ServerName nvarchar ( 50 ), D...
Tuesday, 23 July 2019
SQL Server : Truncate all Tables of a Database
›
A script to truncate all tables of a Database in Sql Server. One of major the problem with table truncation is, we need to remove if ther...
Monday, 22 July 2019
SQL Server : Stored Procedures Ignore User’s Permissions
›
According to this MSDN documentation : Stored procedures take advantage of ownership chaining to provide access to data so that users do...
›
Home
View web version