I am trying to pipe the output in powershell .Write-host $host | out-file output.txt? This is not working. where as if i just type in as $host | out-file output.txt this seems to work. Also while working with SQL , i gave the command as $server.databases | get-member. I was able to see the property Storedprocedures for the databases , but when i am trying to give it as $server.databases.Storedprocedure i am not getting any output The same i tried to do as below: foreach($db in $server.databases) { write-host $db.Storedprocedure } This time it worked.What is the difference? Also can u please explain the following Statements $cryptoServiceProvider = [System.Security.Cryptography.MD5CryptoServiceProvider] $hashAlgorithm = new-object $cryptoServiceProvider