SMO vs SQL-DMO

Question

SMO vs SQL-DMO

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply

David McKinney SSChampion Points: 10472 More actions · Answer 1

He does say 'scripting operations' so I'm assuming he's talking about scripting objects etc..

Is this what you're referring to, Jeff, when you talk about a T-SQL solution? (String building?)

I've been pretty underwhelmed with both SQL-DMO and SMO when it comes to scripting and have on occasions used an xml / xsl solution to achieve a more custom result. [/url]

(but it's not everyone's cup of tea!)

Regards,

David.

David McKinney SSChampion Points: 10472 More actions · Answer 2

Ninja's_RGR'us (1/28/2009)
I was subscribed to this thread as well. And Jeff only replied to it because someone else posted another solution a couple minutes before him.
When replying to a thread, I never checked when the op started the thread, only if I have something valiable to add to it. When someone trolls here from google, the date of the thread and replies have no bearing on helping him towards a solution.

this is true....but I was only kidding!

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 3

David McKinney (1/28/2009)
He does say 'scripting operations' so I'm assuming he's talking about scripting objects etc..
Is this what you're referring to, Jeff, when you talk about a T-SQL solution? (String building?)
I've been pretty underwhelmed with both SQL-DMO and SMO when it comes to scripting and have on occasions used an xml / xsl solution to achieve a more custom result. [/url]
(but it's not everyone's cup of tea!)
Regards,
David.

Sripting objects, doing stuff on the "outside" because they don't know a way to do it "inside" (like the supposedly impossible import I just got done writing at work), whatever. For example, I know lots of folks that will write a script to get file names from a directory... xp_DirTree works just fine and I don't have to go to the wood shed to find the tool. Yeah, I know... "Undocumented features can go away at the next service pack." So can documented ones... look what they did to the very well documented sp_MakeWebTask privs in 2k sp4. WHAM! Suddenly, it needs "SA" privs... broke a hell of a lot of code. Or how about what they did with the {f4} key functionality when they shifted from 2k to 2k5... all gone! Replaced by some POS filter technology in the object tree.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004313 More actions · Answer 4

David McKinney (1/28/2009)
Ninja's_RGR'us (1/28/2009)
I was subscribed to this thread as well. And Jeff only replied to it because someone else posted another solution a couple minutes before him.
When replying to a thread, I never checked when the op started the thread, only if I have something valiable to add to it. When someone trolls here from google, the date of the thread and replies have no bearing on helping him towards a solution.
this is true....but I was only kidding!

Heh... me too! I ALWAYS have enough coffee even if I have to chew the grounds. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

David McKinney SSChampion Points: 10472 More actions · Answer 5

Sripting objects, doing stuff on the "outside" because they don't know a way to do it "inside".

OK...I get you. I immediately thought more of 'script generation' i.e. Create Table etc.. (I hate the script generation in SSMS - hope it's improved in 2K8.)

And i'm always in admiration of those who use T-SQL to do the 'seemingly impossible', even if personally it often hurts my head too much, and I resort to more conventional means (or delegate!) 😛

David McKinney SSChampion Points: 10472 More actions · Answer 6

For example, I know lots of folks that will write a script to get file names from a directory... xp_DirTree works just fine

Hi Jeff,

Does this really work for getting a list of files? I can only get a list of subfolders from it. Am I missing a parameter? (My wife says I am.)

Thanks,

David.

David McKinney SSChampion Points: 10472 More actions · Answer 7

....found it!

EXEC master..xp_dirtree 'C:\temp',@depth, @includefiles

e.g. EXEC master..xp_dirtree 'C:\temp',1,1