Thanks guys. It is one of the strange ironies of my life that although I can write code faster than most people, I am excruciatingly slow (and error-prone) at...

Dang it! I hate how slow I am on posts... :angry:

Gus already explained the STUFF trick to take away the leading comma, so I will try to explain the XML PATH trick. Not because I am an XML Guru,...

The issue isn't whether it's supported in some language, the issue is whether it happens...

Aside from FTE & the Soundex trick, almost every other solution that you come up with here will share the same problem: they are not SARGable, so if you apply...

Stuff that I have noticed:

1) It is using graybar striping background. I realize that its trendy on forums right now, but the Pro's say that background noise like...

True, but code should not be formatted in a proportional font, for this very reason.

{oops: posted in wrong form. My post makes no sense here, so I am wiping it...}

You can execute DML...

prince0206 (3/19/2009)

---

Hello there,

Thanks for your infor... As I am working on a product which uses these SQL apis will support only DMOs so I need to live it with DMO...

I do not believe that DMO will work with SQL Server 2005, will it?

Tools menu:

Options..

On the navigation pane pick: Text Editor: Transact-SQL: Intellisense

Turn off "Enable Intellisense"

It's probably the intellisense. Try turning it off.

I cannot help you with C++, however, I can tell you that you probably want to use SMO rather than DMO.

Do you have an open transaction?