SQL documentation tools and permissions required

Database documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:

Views – 126

PASS 2015 – Seattle WA – Day 3

PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…

T-SQL Querying and Query Processing Order

The order in which we write T-SQL queries happen in this order:

however, the order the Query Processor on SQL Server processes…

How to identify IDENTITY columns tables in a database

Here is a nifty query that will display all the tables and columns set as IDENTITY in a given database:

Views –…