Cover Image
Read Now

Real-World SQL-DMO for SQL Server

Real-World SQL-DMO for SQL Server delves into the details of administering Microsoft SQL Server using the SQL-DMO object library. Authors Allan Mitchell and Mark Allison have packed the book with explanations and working code that will help you use the library to its full potential. Additionally, Mi...

Full description

Bibliographic Details
Main Authors: Mitchell, Allan, Allison, Mark (Author)
Format: eBook
Language:English
Published: Berkeley, CA Apress 2003, 2003
Edition:1st ed. 2003
Subjects:
Software Engineering
Software Engineering/programming And Operating Systems
Database Management
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
Table of Contents:
  • 1 Getting Started with SQL-DMO
  • 2 Backup and Restore: A DBA’s Bread and Butter
  • 3 Managing Users of Your Database and Server
  • 4 Using SQL-DMO with OLE Automation
  • 5 Jobs, Alerts, and Operators
  • 6 Viewing and Setting Server-wide Options
  • 7 Replication and SQL-DMO
  • 8 QALite
  • 9 Using SQL-DMO to Script an Entire Server
  • Appendix A SQL-DMO Object Library Quick Reference
  • SQLServers Collection
  • Databases Collection
  • DatabaseRoles Collection
  • FileGroups Collection
  • DBFiles Collection
  • FullTextCatalogs Collection
  • StoredProcedures Collection
  • Tables Collection
  • Columns Collection
  • Users Collection
  • Views Collection
  • Triggers Collection
  • Jobs Collection
  • JobSchedules Collection
  • JobSteps Collection
  • Operators Collection
  • Logins Collection
  • Replication Object
  • The SQL-DMO Object Model
  • Appendix B Knowledge-Base Articles and Other SQL-DMO Resources
  • Bugs
  • Fixes
  • Problems
  • Information and How-To’s
  • Useful URLs

Similar Items