How do you say: I second-second that ?!?

And while we're at it, would it make sense to create a forum for authors?...

...keep'em comming

Thanks Noel. Never says never. But if I have my way here, three's enough.

We have some recordings from my wife when she was a kid. That's incredible....

If this is for your own maintenance, I'd say there is not wrong in using a cursor.

Well, you always can have a look at the source code of sp_spaceused to see what it does and modify it for your needs. However, I would first search the...

Do:

SELECT

 *

FROM

 INFORMATION_SCHEMA.SCHEMATA

WHERE

 CATALOG_NAME

NOT IN

 ('master', 'model', 'tempdb', 'msdb', 'pubs', 'northwind')

sp_MSforeachDB is undocumented, and directly querying the system tables isn't the best solution either.

Looks like I don't need to search TechNet anymore. guess I had better scrolled up that thread *before* replying. Thanks for the links! This time I'll keep them.

Many, many thanks to everybody who replied !!!!!

I forgot to mention her name: Nina Marie 

I really enjoy...

Ach so...

Yes, this "auto-parsing" feature makes code posted here sometimes hard to read.

Frank, would you mind elaborating on your commment about temp tables?  I was under the impression that table variables typically incurred less server cost during use.

Or, are they typically...

Now come on, it's never a holiday with a new-born is it

No, not really. But it depends on how easily one lets oneself get stressed. And after two boys I'm...

Phill,

sorry, I really wasn't aware, that you're almost 10 hours ahead of my timezone.

Due to my new-born little daughter I have now...

I have a laptop from my work I almost always use (going online with it is free ). Apart from this I...

...or something like http://sqldev.net/xp/sp_smtp_sendmail.htm

You might have noticed or not, that Snitz forum software isn't used here anymore.

Only the geek test, Steve mentioned in his article. but to be honest, I outperformed him by far. I think my last result result was well above 50%