Advanced Search

Return to Snippet

Revision: 62967
at March 27, 2013 04:10 by jprochazka
Updated Code 
EXEC sp_configure 'show advanced options', 1
RECONFIGURE

EXEC sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE

Revision: 62966
at March 27, 2013 03:49 by jprochazka
Initial Code 
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE Test01
AS
BEGIN
    SET NOCOUNT ON;

    EXEC sp_configure 'show advanced options', 1
    RECONFIGURE

    EXEC sp_configure 'Ad Hoc Distributed Queries', 1
    RECONFIGURE

END
GO
Initial URL 









Initial Description





Allows Ad Hoc Distributed Queries using by executing sp_configure.









Initial Title





Enable Ad Hoc Distributed Queries using sp_configure









Initial Tags














Initial Language





SQL