Steve,

Congratulations for passing all those exams.  I would not say Microsoft is evil, as your recent post shows most of the money is generated by Windows which is crowding out...

Sorry I did not cover the 2005 exams and there are many, I have not found study guides for them.  Hope this helps.

http://www.microsoft.com/learning/mcp/mcitp/default.mspx

I have posted a study guide link in the thread below, but you also need practice exams like Transcenders.  Hope this helps.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=10&messageid=361465

Yep you missed something Showcontig is obsolete, try the new version you are not alone most people don't know all the physical of SQL Server 2005 is new.  Try the...

In that case download the 64bits client tools rerun setup and remove the existing version so you can install 64bits client tools.

I think you need to run some tests most updated Join code will break, the details is covered below.  Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms178653.aspx

If I understand you correctly you install 64bits client tools because the version of client depends on what version of operating system is running in the box you are installing...

The CheckBox control is called a black box control Microsoft did not share the internals, there are some user created custom controls you can use for free, see if what...

I found you two possible solutions but they are in C# so I got you the best free code converter too.  You have run into known issues with work around...

I don't know what you mean by putting DVD into Laptop but what I mean is you should copy all the DVD content to your hard drive, then rerun setup...

MikeC,

That is very funny if a junior dba knows the difference between declarative and imperative languages what would a senior dba need to know? 

http://en.wikipedia.org/wiki/Imperative_programming

http://en.wikipedia.org/wiki/Declarative_programming

There is no 64bits Enterprise Manager for 2000 but you can register it to a 32bit version and use the Enterprise Manager.

Try the link below for how to fix your problem, post again if it is not resolved.  Hope this helps.

http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

What you need is covered in the link below but you also need to spend time with the surface area configuration tool documentation in the BOL.  Hope this helps.

http://support.microsoft.com/kb/914277

It is not related to service pack version but context when a system admin runs the job it runs in the context of the system admin, but when others runs...