1. SQL Server 7 can be installed as default instance only i.e you cannot install named instances where as SQL Server 2000 and above versions can be installed as either default or named instance.
2. Local System Account is the default SQL Services login account when you run an unattended installation.
3. If you are running multiple sql servers in your network which are all SQL Server 2000 . What should you choose when installing another instance of SQL Server : Collations
4. SQL Server 2000 collations are similar character sets in previous versions of SQL Server.
5. setup.iss is a installation initialization file
6. SQL Server 2000 can have up to 16 simultaneous instances.
7. You can run SQL Server setup from the installation SQL Server 2000 CD and on choosing the advanced menu generate batch file to run unattended installation.
8.SQL Server 2000 doesn't install Microsoft Search on a Windows 9 X PC .
9. SQL Server default sort-order is Dictionary sort-order case sensitive.
10. The default installation path of named instance would be Program Files \ Microsoft SQL Server \ MSSQL$Instancename
11. When installing SQL Server 2000 you should change the default collation or sort order in the below situations
Using a language besides English
You are matching an older version
Using an application that requires you to do so
12. How to test SQL Server has installed successfully
You can test either by running a query on test database or open enterprise manager and drill down into one of the test database.
13. Default user account will also be the SQL agent and server login.
14. During installation you should select the sort order
15. You install SQL Server 2000 with the server name as test2ksql and now you wish to test the installation using OSQL . How you will do it ?
run this from command prompt : osql /Usa /Ppassword /Stest2ksql
2. Local System Account is the default SQL Services login account when you run an unattended installation.
3. If you are running multiple sql servers in your network which are all SQL Server 2000 . What should you choose when installing another instance of SQL Server : Collations
4. SQL Server 2000 collations are similar character sets in previous versions of SQL Server.
5. setup.iss is a installation initialization file
6. SQL Server 2000 can have up to 16 simultaneous instances.
7. You can run SQL Server setup from the installation SQL Server 2000 CD and on choosing the advanced menu generate batch file to run unattended installation.
8.SQL Server 2000 doesn't install Microsoft Search on a Windows 9 X PC .
9. SQL Server default sort-order is Dictionary sort-order case sensitive.
10. The default installation path of named instance would be Program Files \ Microsoft SQL Server \ MSSQL$Instancename
11. When installing SQL Server 2000 you should change the default collation or sort order in the below situations
Using a language besides English
You are matching an older version
Using an application that requires you to do so
12. How to test SQL Server has installed successfully
You can test either by running a query on test database or open enterprise manager and drill down into one of the test database.
13. Default user account will also be the SQL agent and server login.
14. During installation you should select the sort order
15. You install SQL Server 2000 with the server name as test2ksql and now you wish to test the installation using OSQL . How you will do it ?
run this from command prompt : osql /Usa /Ppassword /Stest2ksql
No comments:
Post a Comment