answersLogoWhite

0

Some disadvantages of using Microsoft SQL Server 2000 include its blocking issues as well as its ability overall to perform as it should. Its ability to be integrated into other systems can be difficult as well.

User Avatar

Wiki User

12y ago

What else can I help you with?

Continue Learning about Computer Science

In which os sql server works?

SQL server is a database developed by the Microsoft corporation. The database is built to exclusively work on Microsoft Operating systems like Windows XP, Windows 2000, Windows Vista etc. It works on all Windows based platforms, but it does depend on the Edition of SQL Server you are going to implement. For example you can run SQL Server Express on Windows Server, but you cannot run SQL Server Enterprise on Windows XP. It will only run on Windows Server systems.


Database made in sql server 2000 can be shifted into sql server 2005?

Yes, a Microsoft SQL Server 2000 database can be hosted on a Microsoft SQL Server 2005 server, and it can also be upgraded to a 2005 database structure under the database properties.---------------Yes it can. You can just attach the mdb file with no problem. 2005 & 2008 are fully compatible with 2000 database files.The action of changing the Compatibility level to the latest value is really optional. I recommend NOT "upgrading the compatibility level". Performance wise, there is no advantage in speed. The Compatibility level is there to ensure features used in the 2000 database are made available to it (ie, some functions are renamed in later version, some are deprecated, etc). So, unless you've done a thorough check (or a very sure), I recommend leaving it at 2000 compatibility.-----------------Yes absolutely, you can do it. Here is top 4 methods that will help you for this.1. Backup & Restore2. Detach & Attach3. Generate Create Script4. Copy Database Wizard using SSMS


What is the difference between a client and a member server?

Client server A Computer Joined In The Domain With Client OS like Windows XP, Windows vista, Windows 7 etc. and Member server A Computer Joined In The Domain With Server OS like windows server 2000,windows server 2003,windows server 2008


What are User Classes and Vendor Classes in DHCP?

http://support.microsoft.com/kb/266675 The following list contains pre-defined vendor classes that are available in Windows 2000 DHCP server. Collapse this tableExpand this table {| ! Class Data ! Class Name ! Description | MSFT 5.0 Microsoft Windows 2000 options Class that includes all Windows 2000 DHCP clients. MSFT 98 Microsoft Windows 98 options Class that includes all Windows 98 and Microsoft Windows Millennium Edition (Me) DHCP clients. MSFT Microsoft options Class that includes all Windows 98, Windows Me, and Windows 2000 DHCP clients. |} If you have non-Microsoft DHCP clients, you can define other vendor-specific classes on the DHCP server. When you define such classes, make sure the vendor class identifier that you define matches the identifier used by the clients. Back to the top The following list contains pre-defined user classes that are available in Windows 2000 DHCP server. Collapse this tableExpand this table {| ! Class ID ! Class Type ! Description | Unspecified Default user class All DHCP clients that have no user class specified. RRAS.Microsoft Default Routing and Remote Access class All Dial-Up Networking (DUN) clients. Bootp Default Bootp class All Bootp clients |} In addition to these pre-defined classes, you can also add custom user classes for Windows 2000 DHCP clients. When you configure such classes, you must specify a custom identifier that corresponds to the user class defined on the DHCP server. For additional information about how to create other user and vendor classes, click the article number below to view the article in the Microsoft Knowledge Base:


What does MCSE stand for?

MCSE usually stands for Microsoft Certified Systems Engineer, which is a title that Microsoft offers to people who are really good at working with their system-level products. People who want to be MCSE certified usually take classes about the products and then they have to take tests to make sure they know the material. If they pass the tests, then Microsoft gives them a certificate that says they passed. Having the certification can often help someone get a job.

Related Questions

How can you install software remotely?

You can do this using server 2000 2003 2008 and Microsoft remote installation service.


What type of software is Microsoft Windows Server 2003?

The Microsoft Windows Server 2003 is software which is an operating system for computers. It was succeeded by Microsoft Windows Server 2008, and followed Windows server 2000.


What has the author Michael J Palmer written?

Michael J. Palmer has written: 'MCSE guide to Microsoft Windows 2000 server' -- subject(s): Accessible book, Microsoft Windows 2000 server, Examinations, Certification, Microsoft Windows server, Microsoft software, Study guides, Operating systems (Computers), Electronic data processing personnel 'MCITP guide to Microsoft Windows server 2008, server administration' -- subject(s): Examinations, Certification, Microsoft Windows server, Microsoft software, Study guides, Electronic data processing personnel


What Microsoft OS is an upgrade of Windows 2000?

Windows XP Professional is the successor to Windows 2000 Professional. Windows Server 2003 is the successor to Windows 2000 Server.


What has the author Jim McBee written?

Jim McBee has written: 'Mastering Microsoft Exchange server 2010' -- subject(s): Microsoft Exchange server, Electronic mail systems, Client/server computing, Microsoft Exchange server (Computer software) 'Microsoft Exchange server 2003' -- subject(s): Microsoft Exchange server, Client/server computing 'Mastering Microsoft Exchange Server 2010' -- subject(s): Computer Technology, Nonfiction, OverDrive 'Exchange Server 2000 24seven' -- subject(s): Microsoft Exchange server, Client/server computing 'Exchange server 2007 implementation and administration' -- subject(s): Microsoft Exchange server, Client/server computing, Electronic mail systems


What operating systems are compatible with the Dell 1100 printer?

According to Dell 1100 specification, the printer is compatible with Microsoft® Windows® XP, Microsoft® 2000 (Professional, Server, Advanced Server, Server running Termianl Services), Microsoft® ME, Microsoft® 98 SE; WHQL approval for Windows XP and 2000.


What has the author Rick Dobson written?

Rick Dobson has written: 'Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET' -- subject(s): Microsoft Visual BASIC, Microsoft .NET Framework, Client/server computing, SQL server 'Microsoft Access Version 2002 Core Reference' 'Programacion Avanzada Con Microsoft Office Access 2003' '1-2-3 Secrets' 'Programming Microsoft Office Access 2003 (Core Reference)' -- subject(s): Microsoft Access 'Professional SQL server development with Access 2000' -- subject(s): Database management, Microsoft Access, SQL server


What type of server manages informational queries from programs like oracle mysql or microsoft sql 2000?

Database Server


Features of Microsoft Windows 2000 server kernel?

what is windows 2000 server features Answer: Microsoft Windows is a series of software operating systems and graphical user interfaces produced by Microsoft. Microsoft first introduced an operating environment named Windows in November 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces.


When was the service Microsoft SQL Server released?

The Microsoft SQL Server is a database and analysis management system that provides recovery services. It was originally released in 2000 and has had several updates and facelifts through the years.


Features of windows 2000 server kernel?

what is windows 2000 server features Answer: Microsoft Windows is a series of software operating systems and graphical user interfaces produced by Microsoft. Microsoft first introduced an operating environment named Windows in November 1985 as an add-on to MS-DOS in response to the growing interest in graphical user interfaces.


What has the author Harry M Brelsford written?

Harry M. Brelsford has written: 'Windows 2000 server secrets' -- subject(s): Accessible book, Microsoft Windows server, Operating systems (Computers), Microsoft Windows NT (Computer file) 'Windows 2000 Server a Fondo - Con CD ROM' 'Active Directory Planning and Design'