It also occurred to me (now) that I could have scripted out all of the stored procedures into one file (or individual files) and searched for 'if exists' or 'drop...

Thanks for your comments, Gail. You nailed it.

We just didn't recognize why our SQL Compare appeared the same, until we could talk to clients and find out how these...

Solved!

We found that some client-vendor scripts were concatenated by clients. There was a missing 'go' at the end of one of them, and the next script dropped this view and...

No replication in this server. No mirroring. Nothing unusual. It is a named instance on this standalone host (no clustering).

Everything works, except saving (permanently) this view yesterday.

Mystery!...

cut an paste... the problem is with CREATE VIEW [usr1].[AIM_WO_COST] ... fails

not this version [usr1].[AIM_WO_COST2] = same content but resident, remains present and useable

The view that fails is named usr1.AIM_WO_COST. No key words or invalid syntax.

It does not matter what schema owns it. We can create dbo.AIM_WO_COST and it will disappear.

If we...