Just found this 1:17 and then at 1:30 system reboots....

The system failed to register host (A) resource records (RRs) for network adapter

with settings:

 The reason the system could not register these...

Nothing in the jobs or agents at all

Nothing in the event logs.....its almost like a manual process someones comes along and moves the...

I have the outlook set up on the SQL Server.

Now in SQL Query...

As soon as i do  this

EXEC master..xp_startmail 

Server: Msg 18038, Level 16, State 1, Line 0

SQL Mail...

The article certainly gives a slant on object usage, however I'd suggest a sql statement vs reads, writes, cpu, duration is of much greater value

How do you measure this part...aswell..that...

I just created this and the

select cisc.objectname, cisc.indexname, ic.scans, floor(scans*cisc.averagerecordsize) as flow

from IndexCaptureSummary ic

inner join CompileIndexesShowContig cisc on cisc.objectid = ic.objectid and cisc.indexid = ic.indexid

order by flow desc

works but...

Thanks for replying...you can't do it through EM when restoring...say you have TESTA logical mdf as TESTA and do restore from TESTB which gives TESTB logical name on EM you...

I just been playing you cannot change the logical name....

Thanks for replying

I did do this set up one sql login...not nt and when i registered to sql for this login...i could see all the databases...when i only gave him one....if you...