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 «««23456»»»

SQL Server Trace Flags Expand / Collapse
Author
Message
Posted Thursday, November 11, 2010 4:27 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 3:29 PM
Points: 74, Visits: 520
Thanks Tim, it's good to see this important list is being updated

Cheers mate
Chris


--Chris Hamam

Life's a beach, then you DIE (Do It Eternally)
Post #1019636
Posted Thursday, November 11, 2010 4:31 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:17 AM
Points: 31,278, Visits: 15,731
Hopefully the author will update this list and resubmit it. If I have time, I'll try to add these as well.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1019640
Posted Thursday, November 11, 2010 4:38 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 268, Visits: 896
Hey thanks for the contribution guys, the web template does not auto imports so I'm manually inserting rows & copying them..... which is taking due time.
Post #1019643
Posted Tuesday, November 30, 2010 4:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 268, Visits: 896
Updated list is online now, few of them appear to blank as I work on them.

Appreciate all the support, any errors or comments do let me know.
Post #1027858
Posted Monday, June 20, 2011 12:39 PM


SSC Eights!

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

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 12:05 PM
Points: 892, Visits: 1,559
How about Trace Flag 902 ? ANy info on this one besides its preventing scripts from running during start up such as those from a service pack update or similar update/install?

As of current I can't get connected to my SQL 2008 R2 instance unless I enable this because the thing gets stuck in the Script Upgrade mode because of a WIndows Security update gone bad. I'm waiting on MS SUpport to call back to fix however I was curious if anyone knows more about this flag such as whether or not is very bad to use it to gain temporary access to non-system DB's?

We have some key info in a SharePOint DB on this SQL Instance that we can't get at because if this problem. I was curious if anyone familiar with this flag knows if enabling it (temporally) so one can get at a non-system DB to get info only (read and no writes) is a definite no-no?

Thanks


Kindest Regards,

Just say No to Facebook!
Post #1128486
Posted Monday, June 20, 2011 12:59 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 268, Visits: 896
At the moment I dont have much info about 902 except what I recall using it under SQL 2000 for Operating system error 5(Access is denied). Rest, let me check will update soon.
Post #1128498
Posted Tuesday, August 9, 2011 9:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 268, Visits: 896
List updated.
Post #1156955
Posted Tuesday, August 9, 2011 9:25 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: Tuesday, November 18, 2014 12:05 PM
Points: 892, Visits: 1,559
yup (8/9/2011)
List updated.


Did the update have anything to do with Trace Flag 902 ? I did not see it in the list but I wanted to verify.



Kindest Regards,

Just say No to Facebook!
Post #1156974
Posted Tuesday, August 9, 2011 9:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 268, Visits: 896
Still working on that and few others.
902 is not in yet.
Post #1156984
Posted Tuesday, August 9, 2011 9:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 1:45 AM
Points: 268, Visits: 896
@YSLGuru did you got any reverts from MS? This was updated less than 50 days ago http://support.microsoft.com/kb/2163980), can you connect to me on yusufanis@msn.com
Post #1157003
« Prev Topic | Next Topic »

Add to briefcase «««23456»»»

Permissions Expand / Collapse