Any time I am running any of the suggested code to grab the deadlock graphs, I am looking at the xml and seeing that object_id in the resource-list is blank....

That's helpful, but it refers to SQL_statement_completed, not sp_statement_completed. Is it possible that sp_statement_completed refers to each statement within the stored proc? I'm still a bit confused...

Several. This is a stored proc that should be a large Method in C# 🙂 Do...

Bump!

I recreated the session and added a ring buffer target as well. When the stored proc was executed once, I found 21 rows of data in the results (events)...

opc.three (2/1/2013)

---

Thanks. Not sure if you are aware but you'll want to watch out for entitization when using the XML method.

Search for 'entitized' on this page for some details and...

We are going to use the FOR XML method....

dwain.c (1/31/2013)

---

Jared - I would be most interested...

Here's my issue...

1. It is not syntactically correct, so it should not work. Just because it solves a problem that many of us have does not make it a...

DiverKas (1/30/2013)

---

SELECT STUFF(( SELECT ''+A.data FROM (SELECT DISTINCT TOP 100 PERCENT data FROM #temp ORDER BY data) A

FOR XML PATH ('')),1,1,'')

Would that not work? I have found that to...

Thanks Scott! Now, in a second question... What do you think is the best way...

Gazareth (1/30/2013)

---

SQLKnowItAll (1/30/2013)

---

After reviewing BOL, I do not see anywhere that it states that the file sizes are copied from model. In fact, the only reference I see to...

What is a "relatively large" database? Can you give us an actual size? I want to rule out other problems... Anthony's suggestion of initializing from a backup would be...

After reviewing BOL, I do not see anywhere that it states that the file sizes are copied from model. In fact, the only reference I see to file size...

pramod.gururaj (1/25/2013)

---

Hi all,

I have to bcp an excel to a table and when i give this command below, it is giving me the following error 🙁

Exec Master..xp_cmdshell 'bcp pmdb.dbo.abc in...