Revision: 62967
Updated Code
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
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
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