SQL-DMO for Beginners

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » SQL-DMO for Beginners

SQL-DMO for Beginners

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Tuesday, August 27, 2002 12:00 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:22 PM
Points: 30,079, Visits: 12,279

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/sqldmoforbeginners.asp

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #6449

Prakash Machiraju

Posted Thursday, August 29, 2002 2:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, September 12, 2011 3:10 PM
Points: 3, Visits: 17

Good article with detailed explanation for programmers who are new to SQL DMO.
Thanks

mssprakash

Prakash Machiraju

Post #40535

rphilips

Posted Thursday, August 29, 2002 9:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 6:08 PM
Points: 28, Visits: 123

Overall this is a good article. The point about blank "sa" passwords was well done! The only thing I would change would be to name the text box and the controls and not leave them as the default command1 etc. Examples should always illustrate good programming habits. Your ample comments are a good model to follow.

Post #40536

Steve Jones - SSC Editor

Posted Thursday, August 29, 2002 9:36 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 4:22 PM
Points: 30,079, Visits: 12,279

Thanks both of you. And I agree. I should rename the controls, even if this is the simplest form

, I may reuse it. And may want to reference the control from another place.

I'll be sure to clean that up in part 2!

Steve Jones
sjones@sqlservercentral.com
http://www.sqlservercentral.com/columnists/sjones

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #40537

spongemagnet

Posted Thursday, August 29, 2002 9:49 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 14, 2012 5:54 PM
Points: 162, Visits: 211

As a dba with very little programming experience I've used sql-dmo in the past in a vb6 app doing the simple task of comparing and promoting tables and stored procedures throughout development, test and production environments..
I'm curious though, what practical applications are there for sql-dmo? Scratching my head and wondering I came up with only a few scenario's. I've seen backup management programs written using sql-dmo. The only time I'd use sql-dmo is if I (pretending I was a programmer) if I had to create a database and oodles of objects. An erp package is a great example of this. And I wanted to do this programmatically.

About the cleanup tasks, good job for mentioning! At the time I'd written my app I had to laugh at myself when looking at all the silly dmo connections left behind on every server I touched.

-Ken

Post #40538

swarm

Posted Sunday, September 01, 2002 11:26 AM

Valued Member

Group: General Forum Members
Last Login: Monday, June 06, 2011 10:53 AM
Points: 52, Visits: 68

Great article. This should have came out before I wrote my first SQLDMO app. I remembered I was having a hard time with that using only the Object Browser and some random net resources. Andy offered great help that time.

This one is very suitable for newbies like me. Hopefully, we'll tackle the more complex issues soon. Right now, I'm still lost with the last problem I encountered regarding my logins being erased after restore. For more info, here's the link http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=6053&FORUM_ID=22&CAT_ID=2&Topic_Title=SQLDMO%2ESQLRestore+erases+loginames&Forum_Title=DMO

"The way to get things done is not to mind who gets the credit for doing them." - Benjamin Howett

Post #40539

Andy Warren

Posted Monday, September 02, 2002 5:43 AM

SSCertifiable

Group: Moderators
Last Login: Yesterday @ 6:51 PM
Points: 6,461, Visits: 1,377

Can you update that thread with what you have for code now? We'll work on it some more! Also, what would you consider good examples of complex issues?

Andy
http://www.sqlservercentral.com/columnists/awarren/

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #40540

« Prev Topic | Next Topic »

Permissions