Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
SQL Server Admin Hacks
From Wiki
This will be categorized once we get 50 or so hacks/tips
Contents [Hide] |
Setup
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. SQL 2000
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. SQL 2005
Fixing Cannot add, update, or delete a job that originated from an MSX Server Error after renaming a server
Security and Permissioning
Grant Execute/SELECT Permissions For All User Defined Functions To A User
Grant Execute Permissions For All Stored Procedures To A User
Find Out Server Roles For a SQL Server Login
Test SQL Server Login Permissions With SETUSER
Meta Data and Object Properties
Find Primary Keys and Columns Used in SQL Server
Get The Domain Name Of Your SQL Server Machine With T-SQL
Check If Auto Update Statistics Is Enabled By Using DATABASEPROPERTY
Three Way To List All Databases On Your Server
Generate A List Of Object Types By Using OBJECTPROPERTY
How to find all the tables and views in a database
Which Service Pack Is Installed On My SQL Server
Find All Tables Without Triggers In SQL Server
Find All Tables With Triggers In SQL Server
How To Get The Database Name For The Current User Process
How To Find Out Which Columns Have Defaults And What Those Default Values Are
How To Find Out If READ_COMMITTED_SNAPSHOT Has Been Enabled For Your Database?
Return all the columns in the database which allow NULLS
Maintenance and Automation
Compare Tables With Tablediff
Create Stored Procedures That Run At SQL Server Startup
Cycle The SQL Server Error Log
Find Recently Modified Stored Procedures
Finding Fragmentation Of An Index And Fixing It
Clear out the procedure cache
Finding Forwarded Records SQL Server 2008
Restore DB and Replication will not start
Deleting files with VBS
Write to file in SQL Server 2005+
Importing and Exporting Data
Manipulating Tables, Indexes, Views, Functions and Procedures
SQL Compare Without The Price Tag
Use OBJECT_DEFINITION To Track SQL Server Stored Procedure Changes
Move A Table To A Different Schema
Backup and Recovery
Find Out The Recovery Model For Your Database
Fix Orphaned Database Users
Bring database out of Standby / Read-Only
Get restore dates for all databases
Profiling and Monitoring
Kill All Active Connections To A Database
SQL Server 2008: When Was The Server Last Started?
How to read sql server error messages
Find Out Who Is Connected To The Database
Getting The Database State For All The Databases In SQL Server
Find Out What The Active Node Of A SQL Active-Passive Failover Cluster Is
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.