Login
Notes

This is a clearing house for various sql statements/tips I've used over the years to maintain, support and report against SQL Server.
FAQs
Q.  How do I detect SQL/MSDE instances?
Q.  How can I report information about current users and processes?
Q.  I want to insert new data from one table into another but preserve the existing data, how do I do this?
Q.  How would I audit for weak sql passwords?
Q.  Is there any way to stop SQL committing transactions in query analyzer?
Q.  what system stored procedure reports permissions for a database object?
Q.  How can I perform actions on all the tables in my database?
Q.  how do i tune my sql queries?
Q.  How would I capture DBCC information?