SET @sql = insert into #TempJobTable EXEC('execute sp_help_job @category_name=N''REPL-Merge'', @enabled=1, @execution_status=4') ___Code for TallyGenerator Daryl AZ Hall of Fame Points: 3087 More actions February 17, 2006 at 11:04 am #621751 SELECT * INTO #JobInfo FROM OPEN...
DECLARE @publication AS sysname; DECLARE @tokenID AS int; SET @publication = N'AdvWorksProductTran'; CREATE TABLE #tokens (tracer_id int, publisher_commit datetime) -- Return tracer token information to a temp table. INSERT #tokens (tracer_id, publisher_commit) EXEC sys.sp_he...
publisher_commit datetime)-- Return tracer token information to a temp table.INSERT#tokens (tracer_id, publisher_commit) EXEC sys.sp_helptracertokens @publication = @publication;SET@tokenID = (SELECTTOP1tracer_idFROM#tokensORDERBYpublisher_commitDESC)DROPTABLE#tokens-- Get history for the tracer...
Table of Contents Status Architecture Example Usage Access your computer in LAN by SSH Visit your web service in LAN by custom domains Forward DNS query request Forward unix domain socket Expose a simple http file server Enable HTTPS for local HTTP service Expose your service in security P2P Mo...
DECLARE @publication AS sysname; DECLARE @tokenID AS int; SET @publication = N'AdvWorksProductTran'; CREATE TABLE #tokens (tracer_id int, publisher_commit datetime) -- Return tracer token information to a temp table. INSERT #tokens (tracer_id, publisher_commit) EXEC sys.sp_helptracertokens...