Understood.  Me?  I export the data to a file and zip it so it won't be a duplication of data in the database.

Works kinda the same way with images... if a...

There may be some normal "healthy" blocking going on... you sure these are "deadlocks" (found in the SQL Server log) and not just blocking?

Not in SQL Server 2000, you can't... this IS an SQL Server 2000 forum, ya know?

Sorry, Chris... lost track of this thread...

Specifically, what statement gave you that error?

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 .