http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/6707.aspxThu, 05 Feb 2009 11:08:19 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6707Diana0http://sqlserver.ro/forums/thread/6707.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6707<P>Foloseste <FONT face="Courier New">DBCC TRACEON <FONT color=#808080>(</FONT>3604<FONT color=#808080>).</FONT></FONT></P> <P><FONT face=Arial color=#000000>Vezi&nbsp;cazuri de folosire&nbsp;foarte bune pe blog-ul lui Paul Randal, de exemplu <A href="http://sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Using-DBCC-PAGE-to-find-what-repair-will-delete.aspx">http://sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-Using-DBCC-PAGE-to-find-what-repair-will-delete.aspx</A></FONT></P> <P><FONT face="Courier New" color=#808080></FONT>&nbsp;</P>http://sqlserver.ro/forums/thread/6706.aspxThu, 05 Feb 2009 11:06:50 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6706Alex0http://sqlserver.ro/forums/thread/6706.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6706<P>am gasit pana la urma</P> <P>trebuia activat trace 3604<FONT color=#0000ff size=2></P> <P>dbcc</FONT><FONT size=2> traceon</FONT><FONT color=#808080 size=2>(</FONT><FONT size=2>3604</FONT><FONT color=#808080 size=2>);</P></FONT><FONT size=2> <P>go</P> <P>alex.</P></FONT>http://sqlserver.ro/forums/thread/6705.aspxThu, 05 Feb 2009 11:06:11 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6705rremus0http://sqlserver.ro/forums/thread/6705.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6705Pentru ca output-ul se duce in ERRORLOG. Ca sa copieze outputul si in rezultat trebuie sa faci enable trace flag-ul 3604: <br>DBCC TRACEON(3604,-1);<br>http://sqlserver.ro/forums/thread/6704.aspxThu, 05 Feb 2009 10:55:50 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:6704Alex0http://sqlserver.ro/forums/thread/6704.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=6704<P>salut, foloseste cineva dbcc page()</P> <P>am urmat pasii de aici:</P> <P><A href="http://www.sqlservercentral.com/articles/deadlock/64315/">http://www.sqlservercentral.com/articles/deadlock/64315/</A></P> <P>doar ca <FONT color=#0000ff size=2></P> <P>DBCC</FONT><FONT size=2> page </FONT><FONT color=#808080 size=2>(</FONT><FONT size=2>5</FONT><FONT color=#808080 size=2>,</FONT><FONT size=2>1</FONT><FONT color=#808080 size=2>,</FONT><FONT size=2>4432</FONT><FONT color=#808080 size=2>,</FONT><FONT size=2>0</FONT><FONT color=#808080 size=2>) </FONT></P> <P><FONT color=#808080 size=2><FONT color=#000000>imi returneaza</FONT></FONT></P><FONT color=#808080 size=2><FONT size=1> <P><FONT color=#808080 size=2>DBCC execution completed. If DBCC printed error messages, contact your system administrator.</FONT></P> <P><FONT color=#000000 size=2>si nu datele care-mi trebuiesc</FONT></P> <P><FONT color=#000000 size=2>aveti idee de ce?</FONT></P> <P><FONT color=#000000 size=2>multumesc</FONT></P> <P><FONT color=#000000 size=2>alex.</FONT></P></FONT></FONT>