Use Powershell to query AD for Users, Groups and GroupMembers
Here a quick script showing how to get all the Active Directory users in a AD group.
a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints…everything.
Find And Replace any string, in the entire table with this function. Parameterized for easy use.
The default trace keeps the last 20 meg of info, and a max of 5 files…This loads all 5 files into a table so it can be reviewed.