xp_sendmail (SQL MAIL) requires an OUTLOOK client. If there is no...

SanjayAttray (7/23/2008)

---

Good article. But, OpsMgr is not as accurate and trust worthy as it has to be. I implemented it couple of weeks back and even though my...

This is something I have been looking forward to for a while.

There is not a lot of SQL-Server-specific SCOM info out there.

Thanks!

shalu (7/21/2008)

---

These are the information I have with me now. Do let me what do think about the counters and how should I proceed further.

System info:

Hardware: Intel Xeon MP...

Well, I have finally been able to come up with the right MDX query, but, although it works in SSMS, it gives me an error in the BIDS project (calculated...

neeraj_nagpal (7/10/2008)

---

I hope its not the case for you, but I got these errors when table had corruption. If you are seeing warnings for a particular object, please run checktable...

noeld (7/16/2008)

---

But I would go even further. When you find yourself in this situation you should try to call the webservice from the "CLIENT" not on the server.

There are...

EdVassie (7/16/2008)

---

I recommend that master DB and resource DB mdf and ldf should always remain in their default locations. The SP2 install does not honour the method given in BOL...

Be very careful about moving master and systemresource db files. They must be in the same location for the SQL 2005 SP2 upgrade to work!

Believe me, I'm talking from...

What is the Max Degree of Parallelism on your instance?

Try sp_blocker_pss80:

http://support.microsoft.com/kb/271509

onlo (7/15/2008)

---

Dear all,

What is the proper procedures of SP2 installation ?

My production server has been running for more than 2 years, I want to upgrade it from SP1 to SP2...

This looks like a good link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=790196&SiteID=1

GilaMonster (7/16/2008)

---

Marios Philippopoulos (7/15/2008)

---

last_execution_time[/b] value in the DMV is, say, from a week ago, wouldn't it be safe to assume that query plans that are a week...

GilaMonster (7/15/2008)

---

Entries disappear from the query_stats DMV when the query plan is discarded from the plan cache....