[dba-SQLServer] Odd Behaviour

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????




More information about the dba-SQLServer mailing list