Can you post the full table DDL including the indexes and the execution plans for both queries?

Can you post the full table DDL including the indexes and the execution plans for both queries?

Is this on a server class machine?  Where is your T-Log physically located?  How big is your T-log?  TempDB?  Make sure there is not any virus scanning software running that...

'don't quite follow all the query rewrites ?? '

Colin, I played around with re-writing the IN clause to a JOIN out of habit.  Although the improvement is only slight, I have...

I think you lost me here.  It will be a big help (to you) to include an example including DDL and sample data and your desired result. 

I would say that your only two real options here would be to use Simple recovery mode or to truncate your log file in between each major data manipulation step. ...

Here's a good thread to reference....

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=328228

This is a pretty straight forward error message and it means exactly what it says.  Something has changed your table schema while the cursor was open.  If you can reproduce this,...

PW's correct.  It is difficult without knowing your data.  Along with changing your UPDATE, you may also benefit from a covering index on TableB Root, Status.  Here's an example that...

On another note, you really do not need to be using dynamic SQL here.  I stayed with it for my example, but if you are passing in the object name...

I think for what you want to do here, this is not really a question of handling the error.  What you want to do here is to check for the existance...

If you can restore it using EM and your SP_WHO2 does not show connected users, your restore should work.  Are you sure you are restoring to the correct DB?  Are...

Basically, just like you did in the SELECT clause.

declare @such nvarchar(52)

set @such = '%' + @Suche + '%'

SELECT

    ResponsibleNI,

    isnull (ResponsibleBZ1, ' ') as ResponsibleBZ1,

    isnull (ResponsibleBZ2, '1') as...

I'm not real sure what you are trying to do here, but your query will not return any rows if either ResponsibleBZ1 or ResponsibleBZ2 are NULL.  A NULL value +...

The table name is Employee.  EmployeeID, FirstName, LastName, and HireDate are all column names.  They've separated the EmployeeID column so that they could mark it as being the Primary Key.