Another very good reason for not setting the PK as a clustered index: some other column may be a better candidate for the clustered index, based on the type of...

rinu philip (7/15/2008)

---

WITH NORECOVERY to WITH RECOVERY

For the above can some one explain what is their difference?

As for the last trans log to be restored we specify with recovery...

It's possible to write a powershell script to enumerate through all services available on the server and pick only those pertaining to SQL (2000, 2005).

Gift Peddie (7/15/2008)

---

Hi,

I have very good news for you because your second post explains the problem in detail and it was not easy to find but Microsoft Isreal posted a...

shahab (7/15/2008)

---

Well avg life expectancy has been going down steadily. at this point its near 800. my db's are fully indexed. so again back to same question. how to estimate...

Gift Peddie (7/14/2008)

---

I really don't understand your question but if you want to exclude anybody in SSAS you can do with DENY permissions because SSAS service permissions are more granular...

Patricia Johnson (7/14/2008)

---

Just to update this post, Here is the message that is received from the job history:

Message

Executed as user: TUSCDC\ATSAdmin. Microsoft (R) SQL Server Execute Package Utility Version...

I found the problem. The startup account for the Performance Logs and Alerts service has to be Local System. After doing that, the problem is gone!

Jeff Moden (7/7/2008)

---

I don't know why folks say that CLR's perform better and are more scalable... it's absolutely not true in about 99% of the cases and several of us...

Jeff Moden (7/7/2008)

---

Marios Philippopoulos (7/7/2008)

---

2) Are you allowed to use sp_OA* procedures?

I don't know much about sp_OA* procedures, but I think they come with their own baggage of problems, and...

Matt Miller (7/7/2008)

---

Marios Philippopoulos (7/7/2008)

---

Matt Miller (7/7/2008)

---

I hate to say it - but you CAN change the errors if you so desire. Just don't have the CLR code "throw"...

Jeff Moden (7/7/2008)

---

Thanks,

Just a couple more questions...

1) Which date are you listing... Create, Modified, or Last Accessed?

2) Are you allowed to use sp_OA* procedures?

3) Do you really need the...

Matt Miller (7/7/2008)

---

I hate to say it - but you CAN change the errors if you so desire. Just don't have the CLR code "throw" the error again: instead...

Here is some sample output:

Date ...

Vivien Xing (7/6/2008)

---

Just read this post today. Are you still looking for the course?

http://www.cmstraining.ca/CourseDetails.aspx?CourseId=56&Product=SCOM

Implementing Operations Manager (SCOM 2007)

July 16 - 18

September 03 - 05

I heard that the instructor is...