Implemented it on my testserver and it went fine.

I always get errorinfo in jobhistory and jobstephistory when applicable .

ok, last shot ....

Can you post the fully scripted job and jobsteps ?

(EM\Management\SQLAgent\jobs and rightclick on your job \all tasks\script it)

try setting the jobowner to sa. SQLserver has some problems with nt-users as jobowner.

- except for the NOINIT / INIT thing it seams OK.

- What says the next line on the sqlserver log ?

- Who is the job-owner ? (script the job)

- can...

Can you detatch the db from EM ?

(rightclick and detatchdb)

- Can you post the jobs script (full !)

- and some job history overview ?

EM detects your user is member of DB-Owner and therefor gives the default objectowner dbo. EM does that kind of stuff

I think what you need is just to add the NOLOCK hint in stead of "transaction isolation level read uncommitted" which may influence your results because you can read uncommitted...

FYI MS has confirmed this to be a problem.

Because the are a number of workarounds (which we described) and we appeared to be the first to report this, no...

test this :

use pubs

go

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

CREATE FUNCTION dbo.udf_convert_date2WeekRange (@RefDate datetime, @FirstLast char(1) = 'F')

RETURNS datetime

AS

BEGIN

    DECLARE @return_date as datetime

    declare @firstdate datetime

    declare @WrkDate datetime

    declare...

- you might consider bulk-copy-recovery model, but you 'll always have some logging.

- can you use @-table-datatype ? (sql2k) this one has less logging then # or @@-temp-tables.

- You might...

if that is what you need .... create a parameter table in which you keep your last or next value per keytype (r/c/...)

Isn't it the same for you application/user if...

Found it back.

Take a look at http://www.dbbest.com/

When using SMSnetworksniffer, I can see that all sql2k servers return the FQDN, but my cluster-instances do not !

Now I have added our...

"set transaction isolation level read uncommitted" is used to avoid waits for locked resources.

table hint (NOLOCK) can be used to avoid read locks on resources.

IMO you should contact your 3rd...