|visits||member for||2 years, 10 months|
|seen||Dec 10 at 16:32|
|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.