Are you getting any errors?

Can you post the code for the function?

Have you tried doing a print or select of @SQLStr and then run that? I'm guessing you need...

Doesn't appear that you can. You would need to apply the MAXDOP to the query referencing the view.

For problem 1 see this blog post by Kalen Delaney.

For problem 2 you are out of luck. Triggers fire as part of the original transaction and any error or...

Here's a query that will find it:

With cteObjectTypes AS

(

SELECT

TSV.trace_event_id,

TSV.subclass_name,

TSV.subclass_value

FROM

sys.trace_subclass_values AS TSV JOIN

sys.trace_columns AS TC ON

TSV.trace_column_id = TC.trace_column_id

WHERE

TC.[name] = 'ObjectType'

),

cteEventSubClasses AS

(

SELECT

TSV.trace_event_id,

TSV.subclass_name,

TSV.subclass_value

FROM

sys.trace_subclass_values AS TSV JOIN

sys.trace_columns AS TC ON

TSV.trace_column_id = TC.trace_column_id

WHERE

TC.[name]...

While all those are good suggestions, I suggest checking out Glenn Berry's blog post here, where he shares his diagnostic queries which includes one on wait stats

Bhuvnesh is correct in saying that you should not just blindly implement these indexes. You need to know which indexes you currently have that are not being used and...

PavanKK (9/20/2010)

---

Hi Forum,

As we are on the way to cleaning Production server, we need to find out the last usage date of each database. sothat we can clean the databases...

Check out this blog post, http://wiseman-wiseguy.blogspot.com/2008/08/ssis-error-logging-custom-component.html. I wrote a custom error handling component where I turn some of the error information into XML. I also reference another custom...

What is the problem you are trying to solve by directly killing a process?

As Gail has asked is this process listed in sysprocesses?

Alvin Ramard (9/20/2010)

---

Steve Jones - Editor (9/20/2010)

---

Doh! Just realized I didn't start the newsletter yesterday. That's what comes from being highly unwired and busy on the weekend.

Fortunately our new hardware...

Anyone else do scrum? I'm in a sprint planning meeting and the goal today is to just pick stories and NOT design. We have a couple of people...

Stefan Krzywicki (9/18/2010)

---

Jack Corbett (9/18/2010)

---

When I've been in a small shop as an employee being a developer/designer didn't get you off the call schedule. Where I worked everyone in...

Stefan Krzywicki (9/17/2010)

---

Craig Farrell (9/17/2010)

---

CirquedeSQLeil (9/17/2010)

---

Brandie Tarvin (9/17/2010)

---

Trey Staker (9/17/2010)

---

I've never...

One of my first tasks in IT was to replace the 100 page green bar reports coming form our AS400 daily with web-based reports that presented the summary data (w/...

CirquedeSQLeil (9/16/2010)

---

Stefan Krzywicki (9/16/2010)

---

Luke L (9/16/2010)

---

CirquedeSQLeil (9/16/2010)

---

Luke L (9/16/2010)

---

Alvin Ramard (9/16/2010)

---

I give up. How can I expect to win when I'm dealing with people that do not appreciate...