Jaykul at huddledmasses has an interesting post on Is PowerShell $ShellId too big a burden? which explains why sqlps.exe, the PowerShell host provided by Microsoft in SQL Server 2008, is a closed shell and lacks support for Add-PSSnapin. To see the shellid run $shellid from the PowerShell host. In regular PowerShell the value is Microsoft.PowerShell and in…