you are right, I tried running select req_transactionUOW

from master..syslockinfo

where req_spid = -2

and it only told me the transaction but not really what it was running, is there any other way...

Thank you Gila, i will find out what the -2 spid is running, it appears it happens constantly.

when i run select * from sys.sysprocesses , i find the spid#, with the blocked column with the -2

then i use that spid and run dbcc inputbuffer (spid#)

and i see...

yes the same spid that is doing the rebuild is the one with -2, I keep checking and is not really blocking any spids. Could it be because there...

the weird thing is that it happens everytime the script to rebuild is ran, could it be something wrong with that certain table?

thanks, but you still have not answered my question, why does the spid which is doing the rebuild index a Negative spid?, (blkd column has a -2) , which is...

i got it sp_helpsubscription

http://msdn.microsoft.com/en-us/library/ms190493(v=sql.90).aspx

🙂

thank you!

thank you guys, that's what i did.

i was afraid of that, thank you

figured it out 🙂

=Format(TimeSerial(0,0,Fields!myint.Value),"HH:mm:ss")

hope it helps someone some day 🙂

thanks for your reply, here you go:

create Proc [dbo].[usp_ReplicationLatency_n]

as

SET NOCOUNT ON

declare @srvname varchar(100)

declare @pub_db varchar(100)

declare @pubname varchar(100)

create table #replmonitor(

status int null,

warning...

This is the error:

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Deferred prepare could not be completed.".

Msg 8180, Level 16, State 1, Line 1

Statement(s) could not be...

ForFiles does'nt support UNC paths, that is why i am trying to use this code 🙂

i tried your code but i keep getting the error The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value. [SQLSTATE 22007] (Error...