• 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!