The SQL Server SMO client API can be used query and alter settings and objects within your SQL Server instances, however in case you want to query your user database, you will run into some limitations. The client API simply isn’t aware of your data objects and therefore not exposing a typed scheme. Fortunately, it’s pretty easy to accomplish when using the SQL Server PowerShell Module (SQLPS)
Recent Comments