Find out which line is giving you the error message. It looks like you are calling another procedure. There is a chance that you get the error in the proc...

Please provide us the create table and its sample data along with the sample reultset. Someone would definitely able to help you better in that case.

Any chance of getting us the execution plan from both of the servers.

Memory utilization is dynamic in SQL server, SQL Server will take care of it very well.

Could you please get us the execution plan?

Could you please provide the servers are in production? If these are in production, I would suggest to use the wizard/query if you dont have SSIS at down time.

You can restart the server before the test and see the reports as Craig Farrell suggested after the test. This would ensure the reports are only showing the stats for...

When you think of split, always remember Jeff's code....:-)

http://www.sqlservercentral.com/articles/Tally+Table/72993/

Not so easy restriction at variable declaration in my knowledge. Lets wait for experts to comment on it.

You can even do a case statement whle assigning the data to the variable.

sqlzealot-81 (7/17/2012)

---

Please refer the bwlo link:

http://beyondrelational.com/modules/24/syndicated/509/posts/12832/tsql-script-generatingconcatenating-values-into-a-comma-separated-string-with-a-grouping.aspx%5B/quote%5D

I guess I understood the question wrongly from the topic text.

Use PIVOT/UNPIVOT for the same. Let me try and get back to...

Please refer the bwlo link:

http://beyondrelational.com/modules/24/syndicated/509/posts/12832/tsql-script-generatingconcatenating-values-into-a-comma-separated-string-with-a-grouping.aspx

GilaMonster (7/17/2012)

---

Google? (Jonathan Kehayias's blog is a good place to start)

Any by archive, I mean query the system health and insert any events you want to keep into an archive...

GilaMonster (7/17/2012)

---

sqlzealot-81 (7/17/2012)

---

However a small doubt, System_health might also not have those details if the deadlock happened for quite long time. It might be overwritten. Please correct me if am...

I agree with Gail.

However a small doubt, System_health might also not have those details if the deadlock happened for quite long time. It might be overwritten. Please correct me...