|visits||member for||2 years, 7 months|
|seen||Sep 19 at 7:58|
|asked||All databases restoring in Suspect Mode in SQL Server 2012|
Performance differences between executing via Linked Server vs. SSMS
Have you considered creating a name-value pair user defined table and passing that in to your SP as the list of Ids rather than a string of Ids? It would eliminate the need for your dynamic sql.