I think that you can create a new backup device (disk), then put your backup file in that location, same name, etc. and perform the restore.

Thanks for the links!

That's the bset link I know of. AFAIK, MS has not published this.

Just confirmed this on my SQL2K, SP3a machine. Not sure why the error isn't displayed, but I think your phrase might ring true here.

A PK is a unique identifier for a row of data. An identity column will auto fill based on some increment each new row. Identities are not necessarily unique or...

you can't do that. 2 solutions:

1: create procedure myproc @pd int

as

declare @cmd varchar(80)

select @cmd = 'select act' + cast(@pd as varchar) + ' from mytable'

return

2: (preferred)

create procedure myproc @pd int

as

if...

See the other post and please don't cross post. We check all forums as a group for new posts.

Is there a db server in each office? When you say you have 6 inspectors, do they all need a complete copy of the db or just a slice that...

So the fix is reset to blank?

Is this an SP3 box? Possibly something in the config I'm not aware of that resets this. If you can't get confirmation on Technet...

If you can split tempdb data and log that's ok, but I don't think it will be a huge impact since this is in simple recovery and only large sorts...

I don't think anyone except the DBA and potentially Sys Admins should have sa access and sys admins only for remote hands/emergencies. This group should be tightly controlled.

On the Unix...

DTS will work. I'm sure there are other ways. Perhaps you can clarify by what you mean with "synchronize", what data, how it should work, schedule, etc.

If this isn't a dev/text db, turn it off. The benfits are far outweighed by the headaches.

2nd vote for Allen's suggestion. you might also run sqldiag and send that as well.

To see the matching values:

select a.pk

    , a.valuetobereplaced

    , b.somevalue

    , b.pk

 from tableA a

     inner join db2.dbo.tableB b

         on a.pk = b.pk

To perform the update:

update a

    set a.valuetobereplaced = b.somevalue

 from tableA a

    ...