|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, March 13, 2012 9:34 AM
Points: 141,
Visits: 61
|
|
|
|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:50 AM
Points: 852,
Visits: 519
|
|
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.
|
|
|
|
|
Ten Centuries
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:20 PM
Points: 1,137,
Visits: 667
|
|
|
|
|
|
SSC-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
|
|
|
|
|
Forum 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...
|
|
|
|
|
SSC-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
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Wednesday, February 20, 2013 3:33 AM
Points: 15,
Visits: 98
|
|
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?
|
|
|
|