How to find the SQL Server Version with a query ?
Categories: SQL Server Tags: Management STudio, SQL Server 2008 R2, Version
How to reset the value of identity Column in SQL Server ?
Here’s a way to reset the value of the identity column in SQL Server . The scenario is explained below . For example , when the table “Customers” has a identity column with the initial value of 1 and seed 1 .Each time when you start an App and perform an operation , you might want to delete all the records inside the table and perform the new inserts . ( Not the best of the methods , but the Ap Read More....Categories: SQL Server, Tools Tags: microsoft, SQL Server, tips, tricks
Restoring SQL Server 2008 R2 Backup file to SQL Server 2008
Recently i had to restore a SQL Server 2008 R2 Database to a Database in another machine and i ended up getting the message "The Database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running 10.00.1600" . Then when exploring the cause of the reason ,i found that the database that i took
Categories: .NET, SQL Server, Visual Studio 2010 Tags: 10.00.1600, 10.50.1600, Endhiran, instances, Kilimanjaro, Rajnikanth, Robot, SQL Server 2008 R2
SQL Server 2008 – Change Edit Top 200 Rows and Select Top 1000 Rows to Select/Edit All
Have you noticed the Context Menu , when you right click on the table in the SQL Server Management Studio Express 2008 . The SQL Server Management Studio Express 2005 allows us to “Edit” or “View” the entire records in a table. You might see the following options in the SQL Server Management Studio Express 2008 . 1. Select Top 1000 Rows 2. Edit Top 200 Rows
Categories: .NET, SQL Server Tags: Context, display, Express 2008, Rows, SQL Server Management Studio
