The report is based on the default trace.

If you open the trace file(s) you can see the hostname

sys.dm_db_index_physical_stats is not specific for any SQL 2005 edition.

But it's a system function, so you won't see it under views.

What exactly are you looking for?

The CPU usage by SQL server in general or the CPU usage for a query?

You can find some information about the general CPU usage...

You might want to check this article

http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

If you're looking in the script section of this site you will find at least 3 scripts. Give a try on a test server and see which will suite you...

Ninja's_RGR'us (11/27/2008)

---

Hi guys, I picked up a script on this site to reindex / reorganize the indexes if fragmentation is over 10% (reorganize) and 30% to rebuild.

The thing is that...

MarkusB (11/27/2008)

---

HanShi (11/27/2008)

---

MarkusB (11/27/2008)

---

No, in your case if you want to restore everything until the last tlog backup (#28) you should start with the last full backup #25 and then...

Wilfred, did you try -UComputername\xxxxx ?

There are a couple of issues with you're script.

First of all in the while loop you should use < instead of <=

Second you have to create a unique jobname for...

Paresh Prajapati (11/27/2008)

---

so, what about, if have recover data up to last transaction log backup of day1 before full backup of second day?

Need to restore full backup of...

HanShi (11/27/2008)

---

MarkusB (11/27/2008)

---

No, in your case if you want to restore everything until the last tlog backup (#28) you should start with the last full backup #25 and then add...

That's obvious I think. When you executed the SP it goes to the ELSE at the end and executes procImportFailClearTables and raises the error. So it's actually behaving just as...

I think you should be more specific what you're looking for. There are lots of scripts...

Same in 2005

what do you mean with syslogins? The table syslogins doesn't have information about the last time a login was used. If you're talking about the logins which are automatically created...