There are two jobs:

One job has two steps: backup database with init and backup log with init runs once a day.

The other job has one step: backup log...

thanks that is better, don't know why this puzzled me, its been a long two weeks...

There are no deadlocks/locks/blocks until I attempt to alter/drop/disable that trigger, than my PID takes over and just simply locks and hangs everyone and everything wanting to touch the Products...

Thanks for the suggestion, tried:

ALTER

TABLE Products DISABLE TRIGGER iu_Products_CartPrice;

still locked/blocked everyone using the web because the...

Hi,

    I'm sure of the spelling because this works

exec @p1 = wmsdb.pdev..sp_QU_QFFLLC_sku_check_insert 'QFFLLC','033787',T

You'll see this commented out ( -- ) in my original post. 

My whole goal is to be...

Hi sushila,

    Thanks for responding.  I tried your code and I got the same error, it says:

WMSDB.pDEV..sp_QU_QFFLLC_sku_check_insert 'QFFLLC','033789',T

Server: Msg 2812, Level 16, State 62, Line 8

Could not find stored procedure...

I may have found information that answers my own question.  Please reply if you think I am wrong.  Thanks

At this web site: http://www.microsoft.com/sql/howtobuy/multiplexing.mspx Microsoft says that "...The client computer has...

Solved it.  Within the dts package is a connection to a text file which my colleague had exclusive share access to as d on the server, so he coded the file...

Sorry folks, all's well with SQL Server, I discovered via ping no less that my route table had an erroneous entry, did a route delete to take out the erroneous...

I've tried logging onto the GP2 server as DOMAIN\Administrator and tried to run the job while on the server and it still fails.  Is there anymore informatin I can give...

Thanks for your thoughts. I may be going about this backwards as I am designing the web page I want to see first and then working backward to the...

trigger didn't tell me much other than it disabled after the last run of the night. I next tried to re-create it. That didn't work so finally just...

I'm put an update trigger on sysjobschedule.enabled column. IT seems this is the filed that keeps getting changed from a 1 to a 0 at night. The servers...

Here is the exact script. It is on SQL2000 Standard Edition. Why won't it stay enabled?

-- Script generated on 9/9/2003 11:11 AM

-- By: sa

-- Server: GP1

BEGIN TRANSACTION ...

I figured it out using a couple of temp tables and while loops.

If exists (select * from tempdb.dbo.sysobjects where name = '##tmp01')

begin

drop table ##tmp01

end

If exists (select...