Heh... "CharString"? Better have a look at BOL yourself 😀

It is possible to populate a variable in such a way, but you'll need to use sp_ExecuteSQL... please see Books Online for the example of how.

The reason why it didn't...

Since sp_SpaceUsed returns 2 result sets, I'm thinking that's just not going to do everything you'd expect. Right idea, though. 🙂

I'm not sure if this is the same interpretation that Chris offered, but, #1... I don't ever load data from a text file directly into the target table. I...

Agreed... a 2 operand COALESCE is identical to ISNULL and has the same "problem" with finding nulls, in this case.

To expound upon the point that Matt makes, consider...

DBCC UPDATEUSAGE has nothing to do with statistics.

Oh, one more thing. Does everyone else have the problem with copying out the 'code block' lines and pasting them in QA and they come out all on one line,...

Now, we're talking! I look forward to the...

Heh... I'm a bit more like Clive... write my own tools whenever possible... that way, they do exactly what I want and I can change them if I need to.

SQLServerCentral.com 😉

Heh... sorry Lynn... you're right...

Thanks, Ed... and I fully understand about the "company name" thing... I gave almost the same answer on a similar request for code. Nice to see some "ethics".

Yep, I understand that... I think we're both talking about the same thing... just a different way...

I didn't say it quite right when I spoke of "accuracy" and I appologize......

EdVassie (11/29/2007)

---

Both EM and QA do their scripting using calls to a SQL scripting API. My experience is this can be buggy when you try to get everything scripted...

Trying to figure out what you need and this seems simple to you because you know what you want... but we don't...

You say the copy/paste into Excel is tedious... what...