Template Script: System Proc\sp_servers.sql

USE [master]
GO
IF OBJECT_ID('dbo.sp_servers') IS NULL
    EXEC('CREATE PROCEDURE dbo.sp_servers AS SELECT 1 AS ID')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE dbo.sp_servers
    @INPUT VARCHAR(100) = @@SERVERNAME
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
;

SELECT  s.*
FROM    Util.dbo.Servers s
GO
EXEC sys.sp_ms_marksystemobject
    sp_servers
GO

Description for Template Script: System Proc\sp_servers.sql

Todo
Site Map | Printable View | © 2008 - 2012 NuRoN Consulting, INC | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund
Share This Using Popular Bookmarking Services