Tag: 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…
Read More
#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…
Read More
#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…
Read More
#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…
Read More
#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…
Read More
#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…
Read More