Hi guys,

I can't find any startup procedure at all.

I have also rebooted the server but it didn't fix anything, the hidden plan still runs.  

In SQL profiling i can't see...

Hi,

Is this T-SQL works to check for startup stored procedure?

declare @name1 char(50)

DECLARE all_stored_proc CURSOR FOR

SELECT name from sysobjects where xtype = 'P'

OPEN all_stored_proc

FETCH NEXT FROM all_stored_proc into @name1

WHILE @@FETCH_STATUS =...

Hi Meike,

Thanks for your reply. 

I tried the snippet code.  It's quite handy. 

>Be sure, that all user SID's stored in the sysusers table correspond to the master..sysxlogins. There are...

Hi Carl,

I ran SQL profiler but apart from user queries i can't see any SQL Statements that execute sqlmaint job. 

I used SQLProfiler Standard template and added extra data columns...

Hi,

I tried to disable the current production maintenance plan.  Then no transaction log is backup and even the hidden plan didn't backup transaction log.   Is it possible that this problem is...

Hi Joe,

I checked the Job Scheduler in EM under SQL Server Agent. But i can't find other old plan.    

Philip

Hi,

I am not too sure about the procedure i have above because i am getting a really strange problem with the database maintenance plan i have created for the production...

Hi,

I am new to MS SQL 2000.

I am learning about backup and restore. I am testing various restore methods on the Northwind database. I have changed the northwind database...