that way your usp_ only returns a value.

use raiserror of you want to have an error raised and set the jobstep's "on error" action to "quit job with failure"

Check BOL.

e.g....

SQL2005 ? or wrong forumgroup ?

SQL2000 : make sure your sqlserver / sqlagent serviceaccout has got the needed authority for your network-shares.

This job...

Try to alias the tables and you'll find your problem easy so solve.

select MyAlias.mycol,...

from myschema.myverymeaninglesstablenamefartolongtoread MyAlias

...

if you still cannot find it, post...

how about using a udf ?

read : http://www.sqlservercentral.com/scripts/contributions/592.asp

I also backup master and msdb everytime a scheduled backup is taken (full/diff/log) of any userdb.

Can you force a table-scan on all tables of your db ?

select * from yourtable

Why : so no indexes (except clusterd) are used and only datapages are accessed. This way you...

BACKUP DATABASE [master] TO  DISK = N'\\ribackupsrv\BACKUP\masterfull.bak' WITH  INIT ,  NOUNLOAD ,  NAME = N'master full backup',  SKIP ,  STATS = 10,  NOFORMAT

BACKUP DATABASE [model] TO  DISK = N'\\ribackupsrv\BACKUP\modelfull.bak' WITH ...

early in the morning

it just scripts the non sql7 stuff and haves you run into the...

Keep in mind a trigger fires every time the criteria meets insert or update (in your case) !

How many times do you predict this to happen and measure afterward...

brutforce way :

ALTER DATABASE yourdb  Set READ_only  WITH ROLLBACK IMMEDIATE

ALTER DATABASE yourdb  Set READ_WRITE  WITH ROLLBACK IMMEDIATE

if you want to have a criteria : sp_lock

create table #tmp_splock (

spid int...

That works fine if you don't use any sql2k features or new datatypes (e.g. tinyint, UDF,...)

Even ?

With tables, "order" has no rule, unless you have modeled it (e.g. using identity,..)

with identity, you can have gaps (which should be no problem for your datamodel !)

select colum-list

from...

Can you still script the job ?

if so, do you notice anything weird in the script ?

check out "linked servers" in books online.

If this is only a one-shot event, it is best to use DTS for this kind of stuff.

You may want to read some more...

In addition to Max and Frank's clarifications :

One of the downsides of hints is that you'll have to check if they are needed with every hotfix/servicepack/upgrade you perform.