It is probably a connection timeout, the connection is established when you run in QA and then run the Job.

Increase the timeout.

The other option is the security of the linked...

Looks very funky.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

I believe the problem is that your derived query from (select ...) has too much data.

Solution is to remove the wide column, CallNotes I presume. Join back to the table...

Check openTrans in sysprocesses, if the value is >0 they have open transactions and killing them will result in a rollback of their transaction, and thus possible loss of data....

I believe EGG.com are using SQL Server.

I think you will generally find newer companies on SQL Server because older companies used Oracle because SQL Server wasn't around. The cost of...

FKs never help performance. As has been said when inserting data a check has to be made that the PK value exists. Worse is when you delete a record in...

create a computed column and then index that

i.e.

ALTER TABLE tblAvisosInternet ADD iDate AS Convert(char,Ai_InputDate,101)

CREATE INDEX I_tblAvisosInternet_iDate ON tblAvisosInternet (iDate)

Then USE

SELECT iDate, count(1) AS iAvisos

FROM tblAvisosInternet

GROUP BY...

Interesting reading

http://www.theregister.co.uk/content/28/28040.html

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

Try this have posted as a sciprt as well so should be available soon.

USE master

GO

IF EXISTS (SELECT 1 FROM dbo.sysobjects WHERE name = 'sp_CopyStoredprocedure')

DROP PROCEDURE sp_CopyStoredprocedure

GO

CREATE PROCEDURE dbo.sp_CopyStoredprocedure...

The memory can be configured once running but the setup of NT causes a STOP if more than 2Gb of memory is configured. There is a KB article but I...

The reason is that messages can get sent back to the client these messages can be rowcounts, warnings, errors and messages (i.e. print statements.) When ADO receives a rowcount it...

Not possible no CONNECT BY equivalent in SQL.

Solution I tend to go for is a while loop inserting into a table variable and then joining on the table variable to...

Also remember if putting NT on it, you can't run setup with > 2Gb. not sure if this is the same with 2000. Often there is a bios setting which...

Difficulty is that it is difficult to get smaller drives any more. 18Gb is really the smallest.

I go for

RAID 1 for OS and other binaries

RAID 1 for log (maybe...

Remember only available in enterprise edition

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088