2004-08-25
65 reads
SQL-DMO
Dump SQL Permissions
We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.
2004-03-17
18,155 reads
More Ideas About Using SQL-DMO
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,480 reads
SQL DMO Poster in PDF!
Last year we did a project with Lumigent to create a DMO poster. Part of the agreement allows us to now distribute the PDF version to our readers. It's about a 400k file, print size is 24x36. We hope you DMO users will find it useful.
2003-10-03
1,901 reads
VBScript Class to Return Backup Information
The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.
2003-08-28
6,810 reads
Introduction to SQL-DMO
This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
2007-10-02 (first published: 2003-08-15)
38,802 reads
Lots of Tables and a Little DMO
Andy discusses a recent thread where a reader has very slow login tables with 2000 tables. After writing some DMO code (very handy by the way) and creating some objects, he can't track it down. Have any ideas?
2003-07-30
7,077 reads
RE: Log Shipping from SP2 to SP3
Both servers are on the same domain.No clustering. Both sql services are using same domain admin account now. Previously local admin account. Now backup itself fails. Error 3202: Write on\\servername\dirname\dbname_logshipping_init.bak failed status=64
2003-07-17
RE: DTS package connecting to Oracle server errors in
Yes. I can access the oracle database from SQL Plus (the Oracle version of Query Analyzer) and I have no problem connecting. We are using Oracle Client version 8.0.5 Mark Hottinger
2003-06-25
1 reads
Discuss Content Posted by Viktor Gorodnichenko
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Viktor Gorodnichenko
2003-05-24
3 reads
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers