Wierd........

?????

Are you asking what it means, what you can do about it, why you got it, or something else completely?

To have got that...

Yes, SQL's looking for a table-typed variable called @dbname1 to update, since an update statement must target a table, not a varchar variable.

More important is what are you trying to do?

If...

You missed my point. If you don't FETCH before going into the WHILE, you don't know the value of @@FETCH_STATUS since it is GLOBAL for ALL cursors on a connection....

Nononono The location of the fetches is correct. You left out a necessary BEGIN... END construct. That's why the execution didn't stop.

You must fetch before going into the loop or the...

Is you database in full recovery mode? If so, backup the log. That will truncate the log and allow you to shrink it.

If the database is in simple recovery mode,...

I can't believe I missed that....

There's a few problems with this, other than the obvious that a cursor is in no way necessary here.

You're never using the value you get from the cursor. I'm not...

Remove (dbo.t_Attachments.AttachmentID) from the Group By clause. Since you want a count of it, you don't also want to group by it.

Dynamic sql is, in general, a very bad idea. It, amoung other things, leaves you very open to certain vulnerabilities, eg sql injection. See http://www.sommarskog.se/dynamic_sql.html for more detail

That said...

The error means...

Well 8114 is an error converting data type. My guess is that one of the fields that you're comparing with '' is of a type that empty string doesn't convert...

Hi Killer

You're more likely to get useful responses to this if you post it in the SQL Server administration forum.

This forum is just for discussion of the site's Question...

Do the not null columns have defaults defined on them?

I think you should get a dev/playground database where you can try stuff out before running on live.

Unless I'm misunderstanding...

Update tbl set B=A where B IS NULL

tbl Before

tbl After