1.As far as I know you cannot restrict transaction logging at ndf level.

2.Why do u think querying would create a hefty transaction log?

David,

The choice tells u how soon u want the "Update" to happen on the subscriber. You can have a replication set up to update subscriber once an hour or so...

It will return all the rows in a table. I've seen it being used when "Depending upon condition certain where clause is applied"

The user SQL Agent uses.

Do what Ninja told u to. It works. Just doing DBCC SHRINKDATABASE WILL NOT SHRINK if the DB is set to full recovery mode and Backup and Xaction backup are...

I hope this gives u what u want.

SELECT col1, col2

FROM tbl

/* Get Max Date where Date is not today*/

WHERE tbl.date >= (Select max([Date]) from tbl

   where Cast(Convert(Char(10),[Date],101) as datetime) <...

As soon as ur application reads a row can u flag it as "WORKING" so that ur application does not pick it up?

Looks like you are trying to normalize and denormalized report data and sum it up.

Steven, Is this how the table is designed. what do u do if u have...

Can you add logging or messaging to DTS to see where it is getting stuck and if and when it is getting stuck run sp_who and sp_lock to find any...

Try this:

Declare @memberid as Varchar (50)

Set @Memberid = '999999999'

Select * from dbo.tblClaims_eligible

where membid = isnull(@memberid,membid)

Thanks

Sreejith

I have used Status and exclude system objects(Tables and Procedures)

 SELECT Name ,*

   FROM dbo.SysObjects

  WHERE     XType = 'U'

 and status > 0

order by 1

Am I wrong with that assumption?

Thanks

Sreejith

Try this:

UPDATE _FinalFlat SET

 Tagged = 1,

 WorkStart = GETDATE(),

 UserCode = @UserCode,

 /*@UseIt1 = A.AcctNo */

FROM _FinalFlat A

INNER JOIN QueueComboBox B

ON A.WorkQueue = B.ProgramKeyField

INNER JOIN

(

SELECT TOP 1 AcctNo

FROM QueueOrderBatch

ORDER BY RiskId...

Is this right?

"BACKUP_20061012_023024/backup.dat" or

Or do u want it to be:

"BACKUP_20061012_023024\backup.dat"

Just curious.

Since u are using windows login from APP and connecting SQL through SQL Login there are few options

1. Your procedure is modified to pass username and it takes care of...

You will have to ReInitialize the Replication.