Loading SQL Server Provider
Last night at the User Group meeting I showed a script to load the required assemblies and snapins that enabled the SQL Server 2008 PowerShell provider to be accessible through a normal PowerShell session.
In response to requests at the meeting the script can be obtained from http://blogs.msdn.com/mwories/archive/2008/06/14/SQL2008_5F00_Powershell.aspx
Enjoy
Read the complete post at http://richardsiddaway.spaces.live.com/Blog/cns!43CFA46A74CF3E96!1879.entry