Hi all, I have an old XP Pro SP3 that i should upgrade to Windows 7 Pro ( or maybe Ultimate ). I have 2 SQL Server 2008 SP3 ( a Developer and an Express with Advanced Services ). After the last reinstall of my OS ( because of the crash of the drive C: ), i did an error , i have installed PowerShell V1...
Hi All i have to collect the SSAS properties ("Analysis Server Properties") into a SQL table , i can not find any DMV to get the "Analysis Server Properties" but i am assuming it can be done with PowerShell, can anyone help? I also need the "SSAS Database Properties". bottom...
PowerShell for SQL Server
Filed under: SSIS, PowerShell, SQL Admin, DBA, SQL 2008, SQL, Database, powershell get-sqldata iterate through get-sqldata resultset sqlpsx library, Verify SQL Server services
I have a SQL 2008 Ent server with the databases "DBOne", "DBTwo", "DBThree" on the server DEVSQLSRV. Here is my Powershell script: $DBNameList = ( Invoke - SQLCmd - query "select Name from sysdatabases" - Server DEVSQLSRV ) This produces my desired list of database...
I second this question, it would be helpful for me as well. I'm also interested in learning how leverage SQL Central Management Server and Powershell.