Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 powershell out-gridview not working

Author  Topic 

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2012-08-15 : 10:55:19
in SSMS, I right-click on a database and select "Start Powershell". Then I enter:

ls tables|out-gridview

but, I get the error message:

quote:

The term 'Out-gridview' is not recognized as the name of a cmdlet, function, sc
ript file, or operable program. Check the spelling of the name, or if a path wa
s included, verify that the path is correct and try again.
At line:1 char:16
+ ls|Out-gridview <<<<
+ CategoryInfo : ObjectNotFound: (Out-gridview:String) [], Comman
dNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException




What should I do to be able to use out-gridview?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2012-08-15 : 15:53:56
I have learned that SSMS does not launch full PowerShell, but a "minishell". Some cmdlets are not available. This is changed in SQL Server 2012 to the full powershell.
Go to Top of Page
   

- Advertisement -