I did not know you were preparing for 2000 I would have helped, here is a link to help you know the material covered for 70-229 study the material and...

Thanks, you have covered what I am trying to get across, the product changed and they did not get how much which is very sad.

That is not what the posting by Microsoft support says and I agree.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=61&messageid=362187

Most of what you need is covered in the link below but a good place to start is click on show execution cost in Management Studio and run the code...

Yes that is all because now the installer will enable Reporting Services as one of your options when you rerun Setup.

Copy the contents of the DVD to your hard drive then install IIS and rerun setup and choose repair and Reporting services will now be enabled so you can select...

I have read your post and the BOL and I am assuming Microsoft did not run their test with NText, I think their test was run with NVarChar(Max) which keeps...

I am not sure but the BI Management Studio does not load when you are running Team Suites in the same box because when I click on mine it opens Visual...

The link below is more detailed in the BOL, it is the place to start, the index subsystem which we ANSI SQL writers call the physical is all new with...

I know that book was not written for SQL Server 2005, it will not help the person to write code that will be rejected by SQL Server 2005.

I would not recommend the book in the thread below to some one new to SQL Server, my advice install the product and run searches for code samples on MSDN2...

The problem is related to Windows file permissions for the Access folder, try the link below for details.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=836809&SiteID=1

Microsoft have created the database deployment toolkit which help you to deploy your database in a hosting company's server, if you are hosting it in house you can just backup...

In 2005 you have to use the surface area configuration tool to enable SQL Server to allow remote connections, all you need is covered in the link below by Microsoft....

Actually unless you need the Agent everything in the regular is in the Express Advanced.  Try the link below to download the version with Management Studio and more with service...