Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 DBCC Command Quick Reference Expand / Collapse
Author
Message
Posted Monday, November 22, 2004 3:05 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 13, 2012 9:34 AM
Points: 141, Visits: 61
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/colum


Jon
Post #147603
Posted Thursday, December 16, 2004 2:53 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, May 9, 2014 8:31 AM
Points: 861, Visits: 544

I was just wondering if this research is relevant for the standard and enterprise editions if SQL 2005 as it was generated against the 2005 express edition beta. Are DBCC commands fully compatible between express and the other editions of SQL Server ?

Still, very interesting article.




Post #151355
Posted Friday, December 17, 2004 12:28 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 18, 2014 7:02 AM
Points: 1,140, Visits: 701
Good job. Very helpful article!

--
Adam Machanic
SQL Server MVP
SQLblog.com: THE SQL Server Blog Spot on the Web
Post #151664
Posted Wednesday, December 22, 2004 4:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 13, 2012 9:34 AM
Points: 141, Visits: 61

Thanks guys. Yes Steve, so far as I know, DBCC commands are common to all versions of the database engine, although I would not rule out minor differences in the effects that they have, or whether they return any useful data for all versions. As soon as I can get my hands on the standard/enterprise edition, I'll post back here to let you know.




Jon
Post #152131
Posted Wednesday, May 18, 2005 12:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, May 18, 2005 1:16 AM
Points: 1, Visits: 1

The article is very helpful.

I wonder if anyone knows about the new syntax of DBCC PSS ? It seems like it does not accept the session_id for now...

 

Post #183219
Posted Monday, May 23, 2005 6:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, March 13, 2012 9:34 AM
Points: 141, Visits: 61
Kolya,
I don't know specifically, but will try to find out. Should be able to post some info. soon with regard to whether the DBCC command set is the same for the latest CTP of SQL Server 2005, and note any differences. Watch this space.
Jon.



Jon
Post #184470
Posted Friday, February 8, 2008 3:35 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 4, 2013 8:26 AM
Points: 15, Visits: 99
I need to the new sintax of DBCC PSS. Sql server 2005 answers this to the DBCC:

Msg 2526, Level 16, State 3, Line 1
Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.


Or is there another way to get other users current isolation level?
Post #453132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse