Now that error is not coming it was my mistake not yours.

deletion activity is pending as below yet..

I want to know one thing ..If I am deleting data using join...

C1 is the primary key...

Hi Phil and king Thanks..

delete a

from T1580 a

inner join T2115 b on a.C301289100 = b.C1000000161

and b.C7 < 5

this query will delete my actual data I want to delete...

Its giving syntax error,I have changed the query with my actual can u help on that.

Can we use join in delete statement.

Hi vikash,

In my case I want to delete those data which is not selecting in below join any Help..

DELETE ord FROM Orders ord INNER JOIN Customers c(nolock) ON ord.CustomerID =...

I have the transactional replication running on my database,and to release some space i need to delete the 10000000 rows on 3 tables.The data can't be partitioned.

I need to delete...

hi,

I have as approx similar issue:

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/1828bfc9-b9d9-412d-97f6-e8a0568cbbdf

Hi,

After enabling trace 1448 the issue has not resolved.

Thanks for answering..

I have checked from GUI and :

Select * from sys.database_mirroring_endpoints;

and find nothing.

That server is never used for mirroring also.

It is production and needs lots of approval for any change.

very nice

I want to implement this feature in my Production...NLB of Web Server with SQL Server Peer to Peer replication.

which one is better Merge or Peer to Peer replication for High...

In sql server 2008 :

I agree if I run

Select * from sys.dm_exec_sessions;

and run

Kill 3;

It will kill SPID.

But I want to kill Session ID.

so How to kill it?

Same I am getting

After adding 7 new views on publication side ,Till the time publication is synching with subscriber will my user able to get the data?