Comments posted to this topic are about the item Stairway to SQL PowerShell Level 8: SQL Server PowerShell Provider
Does the Provider work for SQL Azure?
Jay Bienvenu | http://bienv.com | http://twitter.com/jbnv
SQL Azure has it's own PowerShell modules.
Hello, great stairway!
I have two instances of SQL server installed, 2008 R2 SP1 and an EXPRESS version I think installed with Visual Studio.
I am able to navigate to
SQLSERVER:\sql\localhost\SQLEXPRESS and even to
SQLSERVER:\sql\GARUDA\SQLEXPRESS (GARUDA is the computer name)
and see the databases as in your examples but have not been able to navigate to the other instance, or to even find what the instance name is, unless it's MSSQLSERVER (which it does not recognize)
I do not do anything with SQLEXPRESS, so can you tell me how to find the instance name and connect through PS?
If you do this:
You should see instances. If you have a default instance then you use the word DEFAULT or default in your path.
If you have a default instance then you use the word DEFAULT or default in your path.
Thanks, Default worked for what I needed.
If you do this:
You should see instances.
This lists a lot of stuff, and the InstanceName property for the default is blank. It was more helpful when I filtered it like this:
dir | Select PSChildName
Is that the property to look at?
I am not sure why you would not see the instances when you use the dir SQLSERVER:\sql\localhost.
Mine shows DEFAULT as the instance name. If I cd into DEFAULT then I see a lot of options. But PSChildName would certainly show you the instances on the machine.
Viewing 7 posts - 1 through 6 (of 6 total)