MCP is not a Seprate Exam but its a collection of different Certificates and the person is Known as Microsoft Certified Professional (MCP)
the Requirements are :
Microsoft Certified Systems Administrator (MCSA) on Microsoft Windows 2000
MCSA: Security on Microsoft Windows 2000
MCSA on Microsoft Windows Server 2003
Microsoft Certified Systems Engineer (MCSE) on Microsoft Windows 2000
MCSE: Security on Microsoft Windows 2000
MCSE on Microsoft Windows Server 2003
Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000
Microsoft Certified Application Developer (MCAD) on Microsoft .NET
Microsoft Certified Solution Developer (MCSD) on Microsoft Visual Studio 6.0
MCSD on Microsoft .NET
Microsoft Certified Desktop Support Technician (MCDST) on Windows XP
See This Page for
Details
MCSE - Official Requirements
70-210 :: Windows 2000 Professional
70-214 :: Adminstering Windows 2000 Security
70-215 :: Windows 2000 Server
70-216 :: Windows 2000 Network Infrastructure
70-217 :: Windows 2000 Active Directory
70-218 :: Managing a Windows 2000 Network Infrastructure
70-219 :: Directory Services Design
70-220 :: Security Design
70-221 :: Network Infrastructure Design
70-222 :: NT4 to Windows 2000 Migration
70-224 :: Exchange 2000
70-227 :: ISA Server 2000
70-228 :: SQL 2000 Administration
70-229 :: SQL 2000 Design
70-270 :: Windows XP Professional
70-290 :: Windows Server 2003 Environment
70-086 :: SMS 2.0
Complete Details about MCSE
Here
MCSD - Official Requirements
70-229 :: SQL 2000 Design
See Details For MCSE .Net
Here