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.

That's the concept of triggers, fire always when from the designed action.

If you have full control regarding the invocation of the designed...

It might even be from a _new_ mainframe db

create function dbo.fnGetNextRecNo(@company xx, @customer xx, @glperiod xx, @transaction)

returns smallint

as

    begin

       ...

If for any reason your database collation is changed, your existing tables will not be affected. If they used the "old" db-collation, they will still use the "old" db-collation, even...

how about :

alter table mytable

alter column mycol type_and_length COLLATE mynewcollation

Ofcourse backup before!!

Maybe even script the full db, create...

the trigger will always be firred, but will only perform some stuf when meeting some criteria.

CREATE TRIGGER TR_mytable_ins ON [Mytable]

FOR INSERT

AS

BEGIN

if inserted.Mycolumn = 'myvalue'

begin

  my work to be done

end

END

Keep in mind that when you have existing indexes with the same column(s), ordinal and direction and you run this script, it will create extra indexes which are redundant, so...