We were planning to implement Application Roles as a way of tightening up security in our .NET applications. We currently have a commonly known and...
-- <br />--' ************************************************************<br />--' Parameters:<br />--' Purpose: Like SP_WHO2 but sorts by...
I use these scripts every now & then to look at all my database backup's history at a glance and make sure everything's happening when it's supposed...
I have a query (QUERY A) that runs in 6+ minutes, and generates an execution plan that doesn't use parallelism. Then, I used an optimization tool,...
From what I've read, SQL2000 shouldn't lock tables during the initial snapshot for transactional replication, I even checked the option : "Do not...
Separate names with a comma.
