A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances. A Tool can do the things as below: 1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...

A Tool **TableDiff** is very useful to compare the schema of tables and data of different SQL instances. A Tool can do the things as below: 1. A row by row comparison between a source table in an instance of Microsoft SQL Server acting as a replica...

Ever had a situation where you had to attach a database when all you had were the data files? Perhaps when you downloaded the AdventureWorks sample databases from CodePlex? Here's a script to attach a database with just the data files using CREATE DATAB...

List out all available Collations in Server...

thanks for the post. really very helpful ....

thanks for the post. really very helpful ....

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...

Hi, We know the hint , how to get all the column names of a table into query window using drag and drop of Columns Folder under TableName. ![SSMS Hint][1] Today , i learned another method to do the same, **Select the query** and **right click**...