Ben

Are there any indexed views, indexes on computed columns , filtered indexes, query notifications, XML...

Nic

I don't think there's a setting whereby you can turn it on or off.  All members of the public role have access to the stored procedure, according to...

Please post the actual execution plans (not estimated) as .sqlplan files for each scenario.  If you're inserting 2000 rows into @p3 and then passing that as the argument for @BusinessObjectDataGuids then that's...

No, that won't work.  You could set up an alias, but I think you'd have to do that on every client computer.

John

Damien

Are you supplying the instance name as well - VIRTUALSERVERNAME\INSTANCENAME?

John

If you want to put results from dynamic SQL into variables, you need to use sp_executesql instead of EXEC.  Or you can take the variables out of the dynamic SQL...

Yes, my mistake.  You were getting a concatenated list of every value in the table rather than every value in a particular string!  Try this:

SELECT
 ...

Or, somewhat more scalably:
SELECT
     c.ID
,    c.LIST
,    r.Reconcat
FROM #CSV c
CROSS APPLY (
    SELECT ',' + s.value
    FROM #CSV c
    CROSS APPLY STRING_SPLIT(c.LIST,',') s
    ORDER...

So what is your problem here - the syntax error, the conversion error, or the performance?  Do you have any control over the code in that view?  If so, start...

I assume that before you detached the database, the tops3_3a.ndf file was on the F drive?  I can't think why your CREATE DATABASE statement isn't looking for it where you tell...

You mean you want to create the same index on the current table as on the new one?  You'll need to query sys.indexes to generate the CREATE INDEX DDL.