SQL Server and Build Numbers

Build chart lists all of the known Service Packs (SP)

	RTM	SP1	SP2	SP3	SP4
SQL Server 2014	12.0.2000.8 12.00.2000.8
SQL Server 2012	11.0.2100.60 11.00.2100.60	11.0.3000.0 or 11.1.3000.0	11.0.5058.0 or 11.2.5058.0
SQL Server 2008 R2	10.50.1600.1	10.50.2500.0/ 10.51.2500.0	10.50.4000.0/ 10.52.4000.0	10.50.6000.34/ 10.53.6000.34
SQL Server 2008	10.0.1600.22 10.00.1600.22	10.0.2531.0 10.00.2531.0 or 10.1.2531.0	10.0.4000.0 10.00.4000.0/ 10.2.4000.0	10.0.5500.0 10.00.5500.0/ 10.3.5500.0	10.0.6000.29 10.00.6000.29/ 10.4.6000.29
SQL Server 2005	9.0.1399.06 9.00.1399.06	9.0.2047/9.00.2047	9.0.3042/ 9.00.3042	9.0.4035/ 9.00.4035	9.0.5000/ 9.00.5000
SQL Server 2000	8.0.194 8.00.194	8.0.384 8.00.384	8.0.532 8.00.532	8.0.760/ 8.00.760	8.0.2039 8.00.2039
SQL Server 7.0	7.0.623 7.00.623	7.0.699 7.00.699	7.0.842 7.00.842	7.0.961 7.00.961	7.0.1063

Create SQL Login

<![if !supportLists]>1.       <![endif]>CREATE a login for SQL Server  for windows authentication

      CREATE LOGIN [domainName\loginName] FROM WINDOWS;    

                                                     

<![if !supportLists]>2.       <![endif]>CREATE a login with password –( SQL Login) this will work from SQL 2000 onwards

CREATE LOGIN VenkatSangu WITH PASSWORD = 'password'

<![if !supportLists]>3.  <![endif]> CREATE a login with password and password must change when the user first time connecting to SQL Server  this will not support in older version i.e SQL Server 2000/2005

CREATE LOGIN VenkatSangu WITH PASSWORD='pwd@123pdw' MUST_CHANGE, DEFAULT_DATABASE=[master], CHECK_EXPIRATION=ON

     

To use MUST_CHANGE keyword must passwords must meet the following guidelines

<![if !supportLists]>·         <![endif]>The password does not contain the account name of the user.

<![if !supportLists]>·         <![endif]>The password is at least eight characters long.

<![if !supportLists]>·         <![endif]>The password contains characters from three of the following four categories:

<![if !supportLists]>·         <![endif]>Latin uppercase letters (A through Z)

<![if !supportLists]>·         <![endif]>Latin lowercase letters (a through z)

<![if !supportLists]>·         <![endif]>Base 10 digits (0 through 9)

<![if !supportLists]>·         <![endif]>Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).

Thanks

Venkat Sangu

List databases from SQL Server 2000

with below query you can List the databases from SQL Server 2000

SELECT CATALOG_NAME 
    FROM INFORMATION_SCHEMA.SCHEMATA 
    ORDER BY CATALOG_NAME