List/Grid Tag Archives: SMO

#PSTip Deleting extended properties on database objects using 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… Read more »

#PSTip Updating extended properties on database objects using SMO

#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… Read more »

#PSTip Reading extended properties on database objects using SMO

#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… Read more »

#PSTip Creating extended properties on database objects using SMO

#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… Read more »

#PSTip Validate is a database is available on a SQL instance

#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…. Read more »

#PSTip Finding all roles a particular login is mapped to in all databases

#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… Read more »

© 2017 PowerShell Magazine. All rights reserved. XHTML / CSS Valid.
Proudly designed by Theme Junkie.