I would guess that you'd probably upgraded SQL Backup and need to uninstall the current stored procedure. To do this, you can use the 'install extended stored procedure' program from the SQL Backup program group to uninstall the current SQLBackup extended stored procedure and run it once more to install the newer one.
To see if SQL Backup's extended procedure is installed, you can run the following from a SQL Server connection (Query Analyzer):
exec sp_helpextendedproc 'SQLBackup'
To manually drop an extended stored procedure, you can also use SQL Server's sp_dropextendedproc stored procedure.
If you run sp_helpextendedproc with no arguments, it will simply list all extended stored procedured on the system. Maybe you can try that and locate sqlbackup in the list?
Can't do that either. It won't let me drop it saying that it doesn't exist and it won't let me add saying there's already a SP by that name. Where would this object exist? Or what table is it in? Thanks
Recently, there was another user who encountered the same issue. Try creating an object in the master database (table or view) and then drop it. Then try adding the extended stored procedure again.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software Beyond compression - SQL Backup goodies under the hood, updated for version 8
Comments
I would guess that you'd probably upgraded SQL Backup and need to uninstall the current stored procedure. To do this, you can use the 'install extended stored procedure' program from the SQL Backup program group to uninstall the current SQLBackup extended stored procedure and run it once more to install the newer one.
To see if SQL Backup's extended procedure is installed, you can run the following from a SQL Server connection (Query Analyzer):
To manually drop an extended stored procedure, you can also use SQL Server's sp_dropextendedproc stored procedure.
exec master..sqlbackup ''
in Query Analyzer? Is your server case sensitive?
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
If you run sp_helpextendedproc with no arguments, it will simply list all extended stored procedured on the system. Maybe you can try that and locate sqlbackup in the list?
It's not listed in when I just run exec sp_helpextendedproc.
I'm wondering if I have to restart the SQL service maybe. it's production so I have to wait.
I suppose if that doesn't work, you could install it manually:
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
SELECT * FROM master..sysobjects WHERE UPPER(name) = 'SQLBACKUP'
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
All I can think of after this is restarting the SQL Server Service. Possibly something is tied up in memory?
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8