Good one ...

Good Question Subhash.....

crazy4sql (9/10/2014)

---

crazy4sql (9/10/2014)

---

PRAMANA.DBA (9/10/2014)

---

HI,

I am getting deadlock in my production, i was taken deadlock information from trace file , i found deadlock graph but i am unable to find exact...

Sean Pearce (9/10/2014)

---

PRAMANA.DBA (9/9/2014)

---

I did below steps,

dbcc traceon(1204)

DBCC TRACEstatus (1204)

TraceFlagStatusGlobalSession

1204101

restarted SQL then i replicated deadlock , in log not showing any thing about deadlock , after that i have verified...

it is .trc file, so it will open in sql...

DBA From The Cold (9/9/2014)

---

Did you restart your local instance after the deadlock occurred?

If you did, the deadlock information would be contained in one of the other error log files:-

ERRORLOG.1

ERRORLOG.2

etc

Have...

I did below steps,

dbcc traceon(1204)

DBCC TRACEstatus (1204)

TraceFlagStatusGlobalSession

1204101

restarted SQL then i replicated deadlock , in log not showing any thing about deadlock , after that i have verified status trace

DBCC...

DBA From The Cold (9/9/2014)

---

With trace flag 1222 running the deadlock information will be recorded in the SQL Server log.

Open up SSMS, then got to Management > SQL Server Log....

Uwe Ricken (8/27/2014)

---

gbritton1 (8/27/2014)

---

The question asks, "What happens", yet one of the "correct" answers is that we need to change the variable and replicate lengths. At the risk of...

Hi all,

I ran below two lines code , then it is working fine.

EXEC sp_refreshsubscriptions N'<Publication Name>'

EXEC sp_startpublication_snapshot N'<Publication Name>'

Good Question....

Good question.