SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[GetPortal] @PortalId int AS SELECT * FROM dbo.vw_Portals WHERE PortalId = @PortalId