I got an offer for Microsoft SQL Server 2000 today, what questions should I ask to know if can it work in a shared enviroment?
sorry if this its a silly question, but I'm kinda donkey when I talk about Windows Licenses.

Thanks in advance.

Mods: if this its not the correct forum, feel free to move it.

Make sure it is one of these versions of SQL Server 2000 listed below otherwise it will not work well with more than 10 users.


SQL Server 2000 Enterprise Edition
Used as a production database server. Supports all features available in SQL Server 2000, and scales to the performance levels required to support the largest Web sites and enterprise online transaction processing (OLTP) and data warehousing systems.

SQL Server 2000 Standard Edition
Used as a database server for a small workgroup or department.

Thanks :)
Anything else that I should ask?

Number of connections (Number of Client Access Licenses) is the most important thing you must ask.

Also SQL Server 2000 standard supports databases under 4G and enterprise does not have any limit.

Mac

The size of a database cannot exceed 2 GB when using the SQL Server 2000 Desktop Engine or the Microsoft Data Engine (MSDE) 1.0.

I am using 45G databases with standard edition and no problems at all.

Is your database file 45G :eek: or database along with log file?

I think I have read this in a SQL server 2000 book that standard version has a limit of 4G.

In fact I myself have databases of about (3G DB + 30G Log) but my databases have not gone over 4 yet.

Mac

data 45G log 3G

Standard edition is used by over 200 clients many with database over 4G.

Everything i posted, i copied right from the SQL books online?