Wednesday, January 2, 2013

MS-SQL Server -2012 Installation Process


 You have to install the software step by step based on your environment

In windows server 2008
1.    Windows server 2008 R2
2.    Windows server 2008 R2 Sp1(For core based installation need R2 sp1 otherwise need only R2)
3.    VS-3.5 sp1
4.    Vs-4.5 sp1

5.    MS-SQL server 2008
6.    MS-SQL server 2008 R2
7.    MS-SQL server 2012

In windows 7

8.    Windows 7 Sp1
9.    VS-3.5 sp1
10.    Vs-4.5 sp1
11.    MS-SQL server 2008
12.    MS-SQL server 2008 R2
13.    MS-SQL server 2012

For More help. .Please browse
http://msdn.microsoft.com/en-us/library/ms143506.aspx

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...