?
Solved

REPLICATION PROD ISSUE ..Urgent .. please help

Posted on 2013-06-21
11
Medium Priority
?
277 Views
Last Modified: 2013-07-21
SELECT CAST(SUBSTRING(command, 7, 8000) AS NVARCHAR(MAX))
FROM msrepl_commands WHERE xact_seqno = 0x000F3AF20031F76E032C00000000 AND command_id = 96


while creating replication it's failing with error Transaction sequence number: 0x000F3AF20031F76E032C00000000, Command ID: 96

I ran above query and found the result as CSTAT

What does it mean and how to fix it?
0
Comment
  • 7
  • 2
  • 2
11 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39267425
What is the compatibility of the publisher and what is the compatibility of the subscriber?
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267428
SQL version is 2005.

<<compatibility of the publisher and what is the compatibility of the subscriber>>
What does this mean and how to check?
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267430
Acperkins:Aappreciate your help..We need to fix this ASAP.Kindly help

Please see the screenshot for the complete details.
Capture1.JPG
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 39267449
What does this mean and how to check?
You use Google and you find and read and understand the following article:
ALTER DATABASE Compatibility Level (Transact-SQL)

Then you run the following query on the Publisher and all the subscribers:
SELECT name, compatibility_level
FROM sys.databases
WHERE name = 'YourDatabase'

If the answer is at least 90, then I have no idea what is going on.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267455
IT'S 90 -SQL 2005
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267462
Repliaction agent is running ...
Can we run post snapshot file separatelg? Is that possible?
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39267530
it seems someone has deleted the subscription... how to identify who has deleted it??
0
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 39267629
how to identify who has deleted it??
Security.  Who has access to the server ? Simply recreate the subscription.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39268048
We have added the AD group.So by default only the member of the AD group. That's clearly understood.But I'm interested specfic member who has performed this action.
Is there a way to find it out?
0
 
LVL 23

Accepted Solution

by:
Racim BOUDJAKDJI earned 2000 total points
ID: 39268064
Unless you have activated a security trailing process, I am afraid that is not possible.
0
 
LVL 5

Author Comment

by:VIVEKANANDHAN_PERIASAMY
ID: 39268493
Can any one please confirm.. please...
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question