LEFT OUTER JOIN usr1.AIM_WO_COST_ENC_ACT B ISNULL(D.ACTUAL_HOURS,0.00) AS ACTUAL_HOURS
ROUND(ISNULL(A.EST_MATERIAL,0.00),2) AS EST_MATERIAL, ROUND(ISNULL(A.EST_LABOR,0.00),2) AS EST_LABOR,
Razorsql equivalent update#
That's why I'm suspicious of this schema update script colliding with something hidden in a system catalog that might have been removed only partially, and thus the system is performing cleanup for us? Possible?
Razorsql equivalent windows#
We can create other objects in SSMS query windows with our same techniques of running queries there, and they remain. It just fails on the production host/server. The usr1.AIM_WO_COST can be created in development sql server an another host. There is no 'if exists.drop' or any of that type of statement in the window. We run the script in SSMS 2008 Query window with auto commit. If we append '2' or '3' we can create those under usr1 or dbo schema, and they remain resident, and useable. We can create dbo.AIM_WO_COST and it will disappear. The view that fails is named usr1.AIM_WO_COST. and nothing stands out.Īny place in any system catalog or view where there might be something that is invalidating or preventing the save of this view permanently? We've run profile while creating the view and quickly selecting it. We're up to date on SP/hotfix for SQL Server 2008. We cannot seem to create it and have it stay created. Select * from INFORMATION_SCHEMA.TABLES where table_name like 'myvie%'Īnd I see our myview2, dbo.myview3, USR1.myview4, but not the USR1.myview that the vendor says must exist. Select * from sys.all_views where name like 'myvie%' Select * from sys.views where name like 'myvie%' Select * from INFORMATION_SCHEMA.VIEWS where TABLE_NAME like 'myvie%' We can create other views as dbo or USR1, and they stay resident. We can recreate it, and select * from it (returning 113,208 rows in 19 seconds), refresh SSMS Views, and the view has disappeared and we now get an error when we try again (Msg 208, Level 16.
Refresh the SSMS Views and two seconds later the view is gone. We see the USR1.myview get created without error. The USR1.myview gets created in development, but not in production host/server/database. We have a vendor application that has worked in development.
0 kommentar(er)
