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...

Step by step dynamic pivot script? Your wish is my command.  It's all out there for you if you search for it.

John

A few things to look out for:
- Indexes that are never used for seeks or scans
- Indexes that are too wide (have more columns than are necessary to...

No, the locks don't cascade up to the views and back down to the other tables referenced by the views.  If you do something to a table, you'll get locks...

Why do you want to store denormalised data in your database, especially when that data is a duplicate of data that is normalised?  If you insist on doing this, the...