If you are using the Visual Studio Team System Database Edition (Data Dude), you will want to upgrade to the latest version that came out at end of April 2009. http://www.microsoft.com/downloads/details.aspx?FamilyID=bb3ad767-5f69-4db9-b1c9-8f55759846ed&displaylang=en
Reason's to update:
If you have to resnapshot a large database, have your remote sites look to a local share (can manually change them whenever via Repl Monitor), pause your replication agent (SQL Agent job) on the subscriber(s) to prevent all the error messages, re-snapshot, zip up the file (I recommend 7-zip), copy the file over with robocopy or FTP to external site if bandwidth better over internet, unzip the files, and startup your replication agent job.
Slipstreaming is a term to update your installs files to a patch level that you are interested in for SQL 2008 only. There is now a Slipstream FAQ on MSDN blogs. If you know all about it, jump right to the how to: SQL Server Setup blog, or the official KB955392. PSSQL blog has another good post on subject.
I was trying to open DTS on a Windows 2008 Server running SQL 2008 only and got an error message:
SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI)
Microsoft released on February 10th a security update for SQL 2000, MSDE and SP2 releases of SQL 2005 including express (SP3 contains the fix; SQL 2008 is not affected by it). http://www.microsoft.com/technet/security/Bulletin/MS09-004.mspx