|visits||member for||2 years, 9 months|
|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.