Could Not Find Stored Procedure Sp_dboption Sql Server 2017

Generally a CLR database object can be used when we want to implement logic that is not possible with T-SQL or it can use more resources. Creating CLR Stored Procedure. Using Microsoft Visual Studio, we can create a SQL Server database project. By adding a 'SQL CLR C# Stored Procedure' item to the project, we can create a CLR Stored Procedure. In this article, we'll create simple stored procedures that will use a single table, and that will be the customer table. What Are Stored Procedures. Stored procedures (SPs) in SQL Server are just like procedures/routines in other DBMSs or programming languages. Each procedure has one or more statements. In our case, these are SQL statements. After we setup replication we found replication was failing with the below error: 'Could not find stored procedure 'spMsupddboPS''. As the error message states, the root cause for the issue is that the stored procedures for replication are not present in the subscriber database.

sp_dbOption not working from sql server 2008 r2 to sql server 2012

May 19, 2014 02:07 AM|badar1983|LINK

SET NOCOUNT ON

CREATE TABLE #TransactionLogFiles (
DBName VARCHAR(150),
LogFileName VARCHAR(150)
)

Could Not Find Stored Procedure Sp_dboption Sql Server 2017 Edition

sp_dbOption not working from sql server 2008 r2 to sql server 2012

May 19, 2014 02:07 AM|badar1983|LINK

SET NOCOUNT ON

CREATE TABLE #TransactionLogFiles (
DBName VARCHAR(150),
LogFileName VARCHAR(150)
)

Could Not Find Stored Procedure Sp_dboption Sql Server 2017 Edition

DECLARE DBList CURSOR FOR
SELECT name FROM master..sysdatabases
--WHERE name NOT IN ('master','tempdb','model','msdb','distribution')
WHERE name IN ('SharePoint_Config')
AND status & 512 = 0

DECLARE @DB VARCHAR(100)
DECLARE @SQL VARCHAR(8000)

OPEN DBList
FETCH NEXT FROM DBList INTO @DB WHILE @@FETCH_STATUS <> -1
BEGIN
SET @SQL = 'USE [' + @DB + '] INSERT INTO #TransactionLogFiles(DBName, LogFileName) SELECT ''+ @DB + '', RTRIM(Name) FROM sysfiles WHERE FileID In(2,3,4)'
EXEC(@SQL)
FETCH NEXT FROM DBList INTO @DB
END

DEALLOCATE DBList

DECLARE TranLogList CURSOR FOR
SELECT DBName, LogFileName FROM #TransactionLogFiles
DECLARE @LogFile VARCHAR(100)

OPEN TranLogList
FETCH NEXT FROM TranLogList INTO @DB, @LogFile WHILE @@FETCH_STATUS <> -1
BEGIN
--PRINT @DB +',' + @LogFile
SELECT @SQL = 'EXEC sp_dbOption [' + @DB + '], 'trunc. log on chkpt.', 'True''
EXEC (@SQL)
SELECT @SQL = 'USE [' + @DB + '] DBCC SHRINKFILE('' + @LogFile + '','truncateonly') WITH NO_INFOMSGS'
EXEC (@SQL)
SELECT @SQL = 'EXEC sp_dbOption [' + @DB + '], 'trunc. log on chkpt.', 'False''
EXEC(@SQL)
FETCH NEXT FROM TranLogList INTO @DB, @LogFile
END

Could Not Find Stored Procedure Sp_dboption Sql Server 2017 Free

DEALLOCATE TranLogList
DROP TABLE #TransactionLogFiles

the above stored procedure i used in sql server 2008 r2 to clear logs of sharepoint databases, but when i installed sql server 2012 and run the stored procedure it is showing sp_dbOption is not available in system databases, when i searched i got to know that they had removed the stored procedure from sql server 2012.

Could Not Find Stored Procedure Sp_dboption Sql Server 2017 Download

I need the similiar stored procedure to clear the logs in sql server 2012, please help me to get out of this issue...

Could Not Find Stored Procedure 'sp_dboption' Sql Server 2017

regards