Unlike the previous version of SQL Server, SQL Server 2000 lets you specify collations for almost any task, at virtually every level within a database — from table column to SELECT statement.

To start the Local SQL Server on your computer, open the Services app by searching it out of the Start Menu. Now, search for SQL Server, right-click on it, select Properties, set the Startup type ...

OK, for some reason, I can't connect to my local SQL Server instance through localhost. Local isn't an option when connecting through Query Analyzer, either. Is there some setting that allows ...

Creating parameters is a great habit to get into so that you can use the same template to create multiple SQL servers, all with different configurations.

The config is: main office/domain with a local SQL server on the domain, users connect using ODBC connection w/ windows auth 2nd company/domain at a remote location, people vpn (windows pptp) to ...

Use the login combination you tried above to verify that a user name and password combination exists for your SQL server. Once you can get the 1> prompt from tsql, we can configure the TDS driver and ...