Open Folder as VS Web Site

Thank you Brad for this.
From VS go Tools --> Macros IDE
Right click My Macros
Add new module named WebSite
Add reference to VsWebSite.Interop.dll
Copy the following into the the WebSite module


Sub OpenWebsite(Optional ByVal path As String = "")
If (String.Compare(path, String.Empty) = 0) Then
MsgBox("Must supply a folder path to the OpenWebsite macro",
MsgBoxStyle.OkOnly)
Else
Dim webPkg As VsWebSite.VSWebPackage
webPkg = DTE.GetObject("WebPackage")
webPkg.OpenWebSite(path,
VsWebSite.OpenWebsiteOptions.OpenWebsiteOption_None,
False)
End If
End Sub


Create a new file named OpenWebSite.reg

Copy the following into this file:

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\OpenVSWeb]
 @="Open as Visual Studio Website"
[HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Folder\shell\OpenVSWeb\command]
 @="devenv.exe /command \\\"Macros.MyMacros.Website.OpenWebsite %1\\\"" 

Double click on OpenWebSite.reg

WSS 3.0 Installation

I recently installed WSS 3.0 on my laptop that is running Server 2008. By default the installation installed the databases in Windows Internal Database which is not what I wanted. I want the tables running SQL Server 2008 instance and I want them named WSS_Config and WSS_AdminContent. Here's how to do it.

1. If you have not done so already, add C:\Program Files\Common Files\microsoft shared\web server extensions\12\bin to the path System Variable. This is a must if you plan to work with SharePoint.
   
2. run psconfig.exe -cmd configdb -create -server SQLServerInstanceName -database WSS_Config -admincontentdatabase WSS_AdminContent
3. Administrative Tools ---> SharePoint Products and Technologies Configuration Wizard

After this completes goto Administrative Tools ----> SharePoint 3.0 Central Administration to create a new site or upgrade an existing web app.