SQL-Articles

Author: Sugeshkumar Rajendran

  • Database Details

    This will list out the Database properties of your database in sql server. This is compatible to SQL 2000 and 2005. Before you use the script make sure you have given the database name for the parameter @dbname.

  • Connection Property

    This script will list out the current connections on SQL 2005

  • Check Identity

    This will list out identity columns in a Database. This is compatible to SQL 2005 only.

  • Trigger Status

    This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.

  • Locks & Locking Hints

    Introduction: Locking, Locks and Deadlocks are words that a developer/DBA does not want to hear in real life but still there are possibilities that we hear them because of some bad code written. This article takes you on to the type of locks available in SQL server and the ways of avoiding them using the…