CODEWITHSUNDEEP
sql-serverpowershell
Eatdoku
Eatdoku

Reputation: 6941

Query SqlServer in Powershell

I have installed Windows PowerShell Extensions for SQL Server 2008 R2

and trying to do the following Add-PsSnapin sqlserverprovidersnapin100 and Add-PsSnapin sqlservercmdletsnapin100

but got the following error

Add-PSSnapin : No snap-ins have been registered for Windows PowerShell version 2. At line:1 char:13 + Add-PsSnapin <<<< sqlserverprovidersnapin100 + CategoryInfo : InvalidArgument: (sqlserverprovidersnapin100:String) [Add-PSSnapin], PSArgumentException + FullyQualifiedErrorId : AddPSSnapInRead,Microsoft.PowerShell.Commands.AddPSSnapinCommand

it is an 32 bit windows 7 machine I am trying to run the powershell on.

thanks.

Upvotes: 2

Views: 1132

Answers (1)

user847990
user847990

Reputation:

I usually just use the command Add-PSSnapin SQL. It easier to remember and quicker to type.

I'm guessing you did install all the the prerequisites such as SQL Server 2008 R2 Management Objects? As stated on the download page this is required.

Upvotes: 2

Related Questions