output

Yup correct, I misspoke on the deadlock graph. It is obviously just a blocked process report. Look at your XML, you have the <inputbuf> node there with the...

You're welcome.

When you create a subscription, it creates an sql agent job.

Since there is a job already there, you could execute that job(that already exists) based on your criteria.

Combine the queries into a single query (if possible).

You could also create parameters in your report that pass different values to a stored procedure. Based on those parameters, a...

You can try a convert to varbinary(64) (sqlhandle as expected by sys.dm_exec_query_text is looking for the varbinary(64)).

In looking at your deadlock graph, you have a sqlhandle that is too large....

I like that one.

Koen Verbeeck (3/11/2014)

---

free_mascot (3/11/2014)

---

Koen Verbeeck (3/11/2014)

---

Great question.

Although the IDENTITY property doesn't always transfer:

When an existing identity column is selected into a new table, the new column inherits the IDENTITY property,...

Glad it is working

any errors in the logs?

QO = query optimizer.

As for how to circumvent those implicit conversions - nothing comes to mind at the moment (without the code rewrite).

That's good news.

The token perm has been a constant problem in 2008, R2 and 2012 though it should be less common than it was in 2005.

it's good to know...

Greg Edwards-268690 (3/10/2014)

---

Pretty sad when they want someone to just do their homework.

Almost makes a person...

If you have the country in the results you are looking at, then you drop the country into the columns section of the matrix.