I am considering implementing SQL Server 2000 within our organisation and I am asking is this a good idea. We are considering using Oracle, but it is expensive. We will eventually have 100+ users using the system and some might be Internet Based. Will there be any problems that might happen with users over 100. I will be using a VB Front end.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Should I implement SQL Server 2000
- Thread starter VBXL
- Start date
tlbroadbent
MIS
SQL Server is very scalable. It will handle 100+ users easily. We currently administer 8 Servers, supporting over 2000 users on the local area network and many others over our wide area network and the Internet.
Our servers have various size databases from a few MB to 4 GB in size. Some servers are limited to 20 or so users while others are open to all users. Concurrent usage on our most active servers is about 200-300 at any given time. We are running SQL 7 on all production servers but will upgrade to SQL 2000 soon.
All of our local deveopment is done is VB. We have a few COTS packages and some MS Access applications as well.
Hope this information helps you. Terry Broadbent
Please review faq183-874.
"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin
SQL is more than capable
Plus its much easier to use and find programmers.
All of Microsoft's Products come ready to connect to it.
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
Plus its much easier to use and find programmers.
All of Microsoft's Products come ready to connect to it.
DougP, MCP
Visit my WEB site to see how Bar-codes can help you be more productive
We are just iplementing a conversion from a unix clone (ManMan) to SQL2k. We have sights across the world (including US and Austrailia). We are setting up VPN (Virtual Private Network) connections for those subsidiaries that have no dedicatede line access to the main server/s.
The only problem I can see you having is the VB front end. It is not the most flexible way of dealing with the front end problem.
We are looking at ASP (active server pages), XML, and cystal reports has been mentioned.
The only problem I can see you having is the VB front end. It is not the most flexible way of dealing with the front end problem.
We are looking at ASP (active server pages), XML, and cystal reports has been mentioned.
- Status