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...

I've done this, but populated a table with the valid business days. Then sum this up. Don't forget that holidays can be business or country specific, so accounting for this...

Sorry, I midread. the instances threw me.

Try running SQL Setup and choosing "Rebuild master"

Steve Jones

steve@dkranch.net

as andy said, create a batch or .CMD file. In it do a "net stop mssqlserver" and a net start mssqlserver (or whatever the service is named).

The NT AT or...

Haven't seen any issues either. Can you give us some more info (browser, os, versions, connection, etc.)

You can email if you do not wish to post (sjones@sqlservercentral.com).

If you have issues,...

Cheapest I have used?

I use my pushFTP process to move the database backups every 15 minutes from production to the QA server. Once a week I restore the QA server,...