ron - here's a link that should give you pointers in the right direction...

link

looks like you're appending to the previous backup instead of overwriting it!!! - that's where I would look first!

Salvatore - FINALLY....the logic that Farrell and I were looking for....

Again, I apologise for not having the time to fully test this as I...

you don't say what other columns you have in your table...regardless - here's one way to do it (source:ken henderson's "guide to t-sql")...

create a second table with an identical structure...

CHAT........I never chat....you must have me confused with someone else!!!

now that makes perfect sense...thx. for the interpretation - would've been puzzling over this all day long otherwise...

that's what my question is about remi - when all the system dbs have a sid of 0x01.. why did andy change the query to....

SELECT name FROM sysdatabases WHERE sid...

I just reread the article to start off my morning with a few laughs and I was wondering about this...

Q: What is the model DB?

A: It isn’t used at all....

you could run a query like this in the master db....

select name, dbname, hasaccess from syslogins

example of combining chris's solution with shawn's alternative would be:

DECLARE @string VARCHAR(10)

SET @string = 'abc'

PRINT SPACE(10 - LEN(@string)) + @string

what about tempdb ?!

Andy - I still don't understand how explicitly eliminating the system dbs works - doesn't WHERE sid 0x01 do just that - not include the system...

dbcc reindex ????

probably not...not with reset to 1

...soliloquy time!!!

Kim - you could run the sproc from QA and under tools - options - results tab - set the default results target to results to file - when you...

The interesting question for me is whether there's any cause-effect there...

sure there is - I just followed the motivation-by-insult link that lee posted...I've often wondered why celko has even deigned...

funny you should say that Merrill...because for me - the single-mindedness - (actually - should correct that to the contemptuous and ridiculing tone of instruction) - has been such a...