Yea Steve, the 2311 was a clear cover.  You could see it spin, the arm also move straight in and out.

One of the links indicated the platter assembly, removable, weighed...

Well I don't have the details, or the time to find all of them.  That is some great work Steve.

I've been in this industry 35+ years, not bad for an...

Well I agree the snail spam is as bad as the espam.  And I realize that recycling paper is a good thing.

BUT IDENTITY THEFT IS A PROBLEM.

And dumpster diving is...

And they had it one the news recently, Gates get 1 million a day !!

If you have the opurtunity, I can't see where it would hurt.

But, make a backup first, and you have to stop SQL Server, at least close the DB. But if...

Look up SP_CHANGE_USERS_LOGIN 'Auto_Fix', 'user'

I think if you add it as a SERVER login, then run the above inside the db in ? it should fix it.

Query Cache had something in it until SQL Server decided to recompile the Query.

I know there is a way to flush the whole cache, but that wouldn't seem to be...

First make a copy of the MDF AND LDF to somewhere safe.

Then look at Attach, either via EM or SP_Attach.  Check BOL for details.

Give this a try, it is an addon to the DBHistory process I wrote a while back.  It collects IO history(Logical), by DB.  You need to schedule it to run...

Try this, if you don't want by s specific DB, jsut rip that part out.

SET NOCOUNT ON

DECLARE @DBName AS VarChar(50)

SET @DBName = '?????'

SELECT

'Distinct Users - ' + CAST(COUNT(Distinct(loginame))...

Too many computers, although technically all MS

SBS2003 as the Domain, Exchange, Proxy, SUS ..

Win2KEE with SQL Server 2000, and UDB, will add Oracle when I get a break. 2gig ram,...

Brian, that was a relatively recent ( 6 to 12 mth) change in licensing. I'm glad you found the specifics, I had only heard comments from MS.

Multiple instances run just...

Just a note though.

I don't think that approach is legal, you have to OWN a copy of the full SQL product to use EM etc against MSDE. Or whatever the...

LEFT(CONVERT(Char(12), CAST(MyNumber AS Money), 1) , 10)

By manipulating the LEFT and the CAST you can control size and # of decimals

Thanks Herb that did it.

I was close, I think I was just thinking too hard.