I have not found a solution as yet...

I am Just maintaining the Logs by using sp_repldone and then shrinkfile..

Any solutions...?

I see the 2 subscribers are continually running and these are...

if you see my question, i have already mentioned the step i do...

Yes it is the replication that is the issue.

even if i run sp_repldone, another transaction comes back, but i am not able to figure out any meaningful information from the...

yes i had gone through all of those blogs, but unfortunately none of those work.. the DBCC OPENTRAN is still showing the same info.

Does a SQL Service restart Help in...

dwivedi.neeraj (4/9/2013)

---

Check this url.. it may help.

http://blogs.msdn.com/b/repltalk/archive/2011/08/23/using-sp-repldone-to-skip-a-transaction.aspx%5B/quote%5D

If you check my question.. I know about that command.. i am curious to now if the column values as mentioned can...

if you check my question.. i have already mentioned the DB is in simple recovery mode, so Log backups are out of...

Anyone..

Best Way is to create a server side TRACE with the Blocking events and monitor the Trace with a TSQL using ::fn_trace_gettable Function from a SQL JOB.

OR Write the...

Do a DBCC SHRINKFILE or from SSMS -> right click the Database -> Tasks -> Shrink - >File (check for available free space - if this is 90% or higher...

Change the job owner to SA or Similar and verify the job...

Try to use a valid Login ID for the SQL JOB (Owner) Use either the SA Account or account with high Priviliges. (Change Owner to SA or etc)

this is the check and see al permission on the system sp.

Try this:

SELECT so.name, user_name(sysperm.grantee) as [Granted To]

FROM master.dbo.sysobjects so JOIN master.dbo.syspermissions sp

on so.id=sp.id

WHERE so.type = 'X'

Order by name

See if this answers your question:

http://support.microsoft.com/kb/822641

yes that is TRUE. so you can search for alternate methods, like there are many custom SP's which do the same thing as the sp_lock.. Or Create another sp_lock SP...