List/Grid Tag Archives: SMO
#PSTip Deleting extended properties on database objects using SMO
Note: This tip requires PowerShell 2.0 or above. In earlier tips, we looked at how to add, read and update the extended properties of a SQL database. In this tip we…
#PSTip Updating extended properties on database objects using SMO
Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we saw how we can read extended properties to a database. In this tip we see how we…
#PSTip Reading extended properties on database objects using SMO
Note: This tip requires PowerShell 2.0 or above. Extended properties are an useful but, under utilized feature in SQL server. In an earlier tip, we saw that you can add extended…
#PSTip Creating extended properties on database objects using SMO
Note: This tip requires PowerShell 2.0 or above. You might have seen several articles on the web discussing about the SQL database extended properties from a self-documentation point of view. I…
#PSTip Validate is a database is available on a SQL instance
Note: This tip requires PowerShell 2.0 or above. Sometimes we need to know if a particular DB is available on a given instance before going ahead and making any configuration changes….
#PSTip Finding all roles a particular login is mapped to in all databases
Note: This tip requires PowerShell 2.0 or above. In a previous tip, we checked out how to get the names of all databases to which a login is mapped and…
