I agree Steve, alternative power should get a higher priority here.

But there are a couple of points to consider.

Solar, somewhere I read/heard (Although I don't believe it, but it was...

Well I agree with paying taxes, I disagree with the way the goverment spends it.

If I waste my money, cool, if someone else does !!!

The goverment has gotten way off...

I just thought it was interesting that our times were exactly the same, 1 hour apart.

Thanks much for the compliments, from you I take that with the highest regards.

Although it...

Funny Steve, we must have posed at the same time in different timezones

Not exactly what you need, but should help.  This deletes greater than n Backups.  It also has the Date as part of the file name.  But see what is returned...

Don't Bother Asking.

Sorry, just had to post this.

PS Farrell, I love you closer

I wasn't born Stupid, I had to study. 

It's been posted on my wall for awhile now.

While I agree the Select provides a cleaner approach.

I've always used a percentage based approach.

If I figure the the majority will be ok, I do an insert and check...

I would agree it's marketing, bad marketing maybe.

But XP reports in as Windows 5 under the covers !!

I think Win2k does also, haven't checked Win2003 yet.

You might have to consider that a Hyper Threaded processor is not really a dual, but a dual pipelined single processor.  With some tricks to allow it to use that...

Look into the event log on the server, there will be markers "DB blah Recovery ?% ..."

That will give you the progress of the backout that Hoo-t was talking about.

The...

All above are good points, and relate mostly to performance.

The primary purpose of a Log file is recovery.  If the data and log are on the same physical drives, you...

Try This, it will build the results in the window of QA.

You can then cut and paste and execute the results.

SELECT '''EXEC SP_ChangeObjectOwner ''' + User_Name(uid) + '.' +...

I believe the limit is 16.

The real question though is why have multiple instances.

There are some good reasons,

Different versions, during migration.

Multiple Test / Development

Active / Active clustering

But in general...

"most of them must be in the age of my dad"

Thanks Frank, I was around before PL/I , so maybe I'm more like your Grandpa. 

Although I have...

Well as I noted in another thread, it's been a long ride.

I've seen this for years, over and over.

The mainframe is dead, you have to learn Unix. While partially true today,...