Showing posts from July, 2007

Setting Trusted Locations in MOSS 2007

Listed below are click-by-click instructions for creating a document library, making it a trusted location, and using it to display an Excel 2007 spreadsheet via Excel 2007 web part.

Create Document Library (with Excel as the default type)
1. Open the Home page to your site collection (i.e. http://moss101/Pages/Default.aspx)
2. Click “View All Site Content”
3. Click "Create"
4. Click "Document Library"
5. Specify all the settings for the library, using Excel 2003 as the default type. For the sake of this example, the document library will be called “Warehouse Documents”.
6. A document library called "Warehouse Documents" is now created, accessible at http://moss101/Warehouse%20Documents/Forms/AllItems.aspx

Make it a trusted location
1. Click "Central Administration"
2. Click "Shared Services Administration"
3. Click the Shared Service (i.e. "SharedServices1(Default)" )
4. Click "open Shared Service Administration"
5. Click "…

SQL Server 2000 End-of-Life Support

For those with projects utilizing SQL Server 2000, Microsoft issued End of Life dates for support.Mainstream Support End of Life - April 8, 2008Extended Support End of Life - April 9, 2013
End of "free" support
Hot fixes (non-security related) will require an extended hot fix support agreement to be purchased
Microsoft will not support warranty support, new features, or design changes
Security updates will continue to be provided

Microsoft Support Lifecycle:
MS SQL 2000 Lifecycle:

With the retirement of SQL Server 2000 around the corner, this brings up an interesting question for MCAD/MCSD candidates: Will this impact certification Exam 70–229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition? When will the exam be retired?

Given Microsoft is still promoting the MCDBA certification on their site, I'm guessing 70-229 is safe f…

Classic UI Tabs for Office 2007

Office 2007 presented users with a new easy to UI, utilizing the new ribbon interface. However, not all users are comfortable with the new UI. A new ribbon customizer tool is available for Office 2007 providing a similar look and feel as previous versions of Office. To preview the ribbon customizer, go to A trial download version is also available.

Debugging Stored Procedure in Visual Studio 2005

This is an interesting article on debugging stored procedures, showing click-by-click directions. To view the full article, click here. In addition, another link was posted on this blog previously at