Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Mitesh Oswal

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

Get the defination of all table type in database

THis script will generate the Drop and create script for all user define table type  Read more...
By Mitesh Oswal 2014/04/18 | Source: SQLServerCentral.com | Category: drop table
Rating: |  Discuss |   Briefcase | 1,056 reads

Get the all user and their server role

The script give you the list of all users and their respective Server roles  Read more...
By Mitesh Oswal 2014/04/02 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,099 reads

Get the Column level difference for 2 database

The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.   Read more...
By Mitesh Oswal 2014/04/10 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 922 reads

Using Seqence Container instead of Identity

This script is an example of how to use Sequence, similar to Identity.   Read more...
Rating: |  Discuss |   Briefcase | 1,162 reads

Get the all the tables on the server which do not have Clustered index

Get the list of the tables on the server which dont have the clustered index.  Read more...
By Mitesh Oswal 2014/02/24 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 1,189 reads

Create a copy of database with a new name

Create Copy of database with new name.  Read more...
By Mitesh Oswal 2014/02/27 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,511 reads
   Items 1 to 6 of 6