Martin Reid
mwp.reid at qub.ac.uk
Mon May 10 02:59:25 CDT 2004
Has anyone seen this before? Not sure what is happening? Is this security related?? Martin create a view using some sql View created I name the view Vw_AssetByAssetTypeRecordset Creates it fine I look in EM View name is [MARTINREID].[BarTracks_Version15T].[dbo].[vw_AssetByAssetTypeRecordset] View when I go to edit it is defined as SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER VIEW [MARTINREID_BarTracks_Version15T_dbo_vw_AssetByAssetTypeRecordset] AS SELECT * FROM [MARTINREID].[BarTracks_Version15T].[dbo].[vw_AssetByAssetTypeRecordset] GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO This only happened today. BEfore this it was named dbo.viewname as usual Any ideas whats going on????