Like a few other people, I experienced a problem installing the Beta 2 Technical Refresh for Microsoft Office SharePoint Server 2007.
Everything went by the book until the “SharePoint Products and Technologies Configuration Wizard” got to the final step, when it failed with an error “could not find stored procedure ‘dbo.proc_MSS_cleanup’”.
The solution is outlined in this newsgroup post (Broken link, was originally www.microsoft.com/office/community/en-us/default.mspx?cat=&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sharepoint.setup_and_administration&tid=e4cab64e-b11b-4266-8751-25e440938fee&mid=2412db7b-436c-4172-8e7f-9ff29e823829&rmid=2412db7b-436c-4172-8e7f-9ff29e823829&helpful=1&p=1&stgxml=http%3a%2f%2fwww.microsoft.com%2foffice%2fcommunity%2fen-us%2fsettings.xml).
Mark mentioned to me today that I’m going to get a new mobile phone! Two possibilities are:
I’d be interested in any suggestions on those or others that I should consider (around the same price range)
I’ve been using the new Microsoft SQL Server Management Studio, the new administrative tool that comes with SQL 2005.
I’ve also kept a copy of SQL 2000 Enterprise Manager installed, because that was the only way I could edit and maintain the DTS packages we have running on our SQL 2000 boxes.
However, today I discovered that if you install the Microsoft SQL Server 2000 DTS Designer Components, which is part of the Feature Pack for Microsoft SQL Server 2005 - April 2006, then not only can you open and edit DTS packages on a 2005 server, but you can also do the same on a 2000 server.
So as far as I can tell, I don’t need to run the SQL 2000 client tools anymore.