CREATE PROCEDURE sys.sp_MSrepl_setOraclepackageversion
(
@publisher sysname
)
AS
BEGIN
set nocount on
DECLARE @retcode int
DECLARE @version nvarchar(256)
-- Security check. 'sysadmin' or db_owner of distribution db required.
EXEC @retcode = sys.sp_MSreplcheck_publish
IF @@ERROR <> 0 or @retcode <> 0
RETURN (1)
-- Set version string from SERVERPROPERTY
SET @version = N'Microsoft SQL Server ' + convert(nvarchar(100),SERVERPROPERTY('ProductLevel')) +
+ N' Version:' + convert(nvarchar(100),SERVERPROPERTY('ProductVersion'))
-- Define sp_ORAremotequery support table
create table #hquery
(
seq int identity(2,1),
cmd nvarchar(4000)
)
-- Set the package version
INSERT INTO #hquery(cmd) VALUES (N'UPDATE HREPL_VERSION SET SQLSERVERVERSION = ' + sys.fn_replquotename(@version, ''''))
EXEC @retcode = sys.sp_IHquery @publisher
IF (@@error <> 0 OR @retcode <> 0 )
BEGIN
DROP TABLE #hquery
RETURN (1)
END
DROP TABLE #hquery
RETURN (0)
END