WITH MyValues AS (SELECT v FROM (VALUES('WAR') ,('WARTEC') ,('TRIAGE') ,('LAB') ,('BDIAG')) x(v) )
SELECT m.v, s.Name, s.ref
FROM #SampleData s
JOIN MyValues m ON s.ref LIKE '%' +...

Not like that, but you could use a table value constructor and join to that.  I think that would work.  If you post up some table DDL (CREATE...

You didn't post the results of the query I posted, but I suspect the user doesn't exist in the target database, or is orphaned.

USE db1
CREATE...

Cathryn

What doesn't work about SET LANGUAGE, and why do you even need it?  Can you not just put the messages in the various languages in a table and...

Yes, that would probably stop the errors.  But you ought to find out why they're happening.  Is it replication that's attempting to do the inserts?  If so, either the article...

Looks as if either somebody is overriding the identity property by setting identity insert on, or the identity has been reseeded.  Is the table in question in the publication database,...

Maybe because it's returning 52 times as many rows?  Please post the query plan and the two actual execution plans.

John

OK, I see.  You should change that parameter name to @TableName, so it's clear what it is.  And are you looking for the Searchname only in the column naam?

So you want to see whether the Searchname appears anywhere in the database?  To do that you'd need to loop through every character column in every table.  If you have...

I tried something like this myself.  I think you need to create a table for the results and then modify the stored procedure to run DBCC CHECKDB with the (undocumented)...

You don't - it doesn't need solving.  Indexes of less than, say, 1000 pages don't benefit from maintenance.  Indeed Ola's code may even specifically exclude them.

John

You're not imposing.  It's just that it's easier to assist someone who wants help with a specific issue, rather than asking for an end-to-end solution.  You should try working through...