It sounds like a security issue. Is the server running as local system? Or a lcoal account? Is it a local administrator.

Is this truly local or a virtual drive for...

That will do it. In 7 you have this option, in 2000, this is "simple" mode.

Steve Jones

steve@dkranch.net

You are welcome and looking forward to seeing you back here. Pls tell your friends and coworkers who use SQL Server

Steve Jones

steve@dkranch.net

Haven't used them mainly because I haven't had any transactions that I use that fit.

If I did a specific update and was concerned about rolling back to that point, I...

You could union these if you did not need the sums on the same row. If you do, then I would use each of these as a sub-select. that's the...

Check the settings for the database. Is it in simple mode? Are non-logged operations being performed?

Steve Jones

steve@dkranch.net

why use local variables? I do the same thing often, but it's something like:

UPDATE SSnumpin

SET PIN = b.PIN,

FirstTimeFlag = b.FirstTimeFlag,

CallCounter = b.CallCounter,

Lastname = b.LastName,

FirstName_MiddleInitial = b.FirstName_MiddleInitial,

EmpNum = b.EmpNum,

PINChangeFlag = b.PINChangeFlag

...

Can you post some DDL to be sure we get this right?

I think you want a single result set, correct?

select sum(a.strCost)

sum( b.strAmount)

from tblItems a

inner join...

You can use osql, just PRINT or SELECT your variable whenever you need output.

Steve Jones

steve@dkranch.net

Dan has good suggestions. Another option is to enhance your app to lock the account after 3 tries. Can be painful, but most password systems (outside of SQL) do this...

IF you have a duplicate PK, this will fail, regardless.

You can update the PK of a table as long as it does not conflict.

Can you post all the code?

Steve Jones

steve@dkranch.net

Double check you restored the right log. Do it in EM and then "view contents"

This is usually what Andy posted, a gap.

Also, do you append or overwrite when you do...

Where are you backing up to? Local or remote drive?

Also can you manually run a backup in Query Analyzer?

Steve Jones

steve@dkranch.net

I'd post some more information under the DTS forum and we'll try to help. Or under the replication section.

Steve Jones

steve@dkranch.net

Ahhh, then I agree ().

I'm usually for SQL Logins, they are easier to deal with and it's easy for NT permissions to get out of hand in...