Just a suggestion...

When someone gives you an example... don't just take it at 100% face value... it's just an example.  When someone suggests something new to you, like QUOTENAME, take a...

Use the SELECT to find out... doesn't matter how much time it takes... it's far better to know ahead of time than fixing "risky data" or having a large rollback...

Heh No... it is a tera-byte database with a lot going on, though.  Web users, billing, invoicing, new customers, Dunning runs, 4 million + new CDR's...

heh... you also bring up another great point... (maybe not intentionally)... If you do like you say with WHERE field <> '', it will inherently NOT find nulls because nulls...

Spot on, Vladan...

So you can't limit the query by level and tree branch on a single click?

Minh...

There's about a thousand posts on this subject on this forum... search for "concatenation".

Nope... I break XML into the appropriate parts and store it as normalized data.

Heh... not supposed to have "gremlins in file systems", Mark.

Do you also store XML in Text columns?

Is the call to the view in an explicit transaction that updated one of the tables in the view?

Doh!  Came up as an "active" thread and didn't even think of checking the original date ... thanks for the heads up, Ken .

Heh... no worries... I've done the same thing when I got in a hurry   I even mispelled "RAND" in my first post...

You need to have another look there fella... I DID use NEWID() in my code... you didn't in your test. 

Then, you're kinda screwed so far as BCP goes unless you want to violate Microsoft Licensing (which I DON'T recommend).  Even with MSDE (which contains a copy of BCP), the...

Heh... you just got control of the situation and now you're going to "have some way for the developers to move approved code in when it is ready."???