Forum Replies Created

Viewing 15 posts - 16,456 through 16,470 (of 49,552 total)

  • RE: DBCC CHECKDB errors

    Odd. I've seen this before and couldn't figure it out then either.

    Does this problem persist across restarts of SQL?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 1:02 pm

    #1542044

  • RE: db_owner and sysadmin unexpected behavior

    sestell1 (9/25/2012)

    So I'm a bit puzzled as to how you were able to see impersonation work with implicit permissions. :unsure:

    You're impersonating a database user. You are not impersonating the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 12:18 pm

    #1542031

  • RE: db_owner and sysadmin unexpected behavior

    sestell1 (9/25/2012)

    GilaMonster (9/25/2012)

    sestell1 (9/25/2012)

    If you impersonate an account that does not have explicit rights within a database, you will not have any rights within that database, even if both accounts...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 12:17 pm

    #1542027

  • RE: db_owner and sysadmin unexpected behavior

    opc.three (9/25/2012)

    My only point was that being a member of sysadmin does not imply there is a user in the db_owner Role named 'sa.'

    No, there doesn't have to be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 12:13 pm

    #1542025

  • RE: db_owner and sysadmin unexpected behavior

    sestell1 (9/25/2012)

    If you impersonate an account that does not have explicit rights within a database, you will not have any rights within that database, even if both accounts are members...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 11:59 am

    #1542016

  • RE: db_owner and sysadmin unexpected behavior

    opc.three (9/25/2012)

    GilaMonster (9/25/2012)

    Any member of the sysadmin role has all permissions across the instance, is implicitly db_owner of all databases and cannot be denied anything.

    To be clear sa is implicitly...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 11:35 am

    #1542004

  • RE: Behavior of "NOT IN"

    And if you do, note from Books Online:

    In a future version of SQL Server, ANSI_NULLS will always be ON and any applications that explicitly set the option to OFF will...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 10:49 am

    #1541988

  • RE: Behavior of "NOT IN"

    OR <column name> IS NULL does not prevent index seeks

    (yes, I used an IN rather than a NOT IN, the NOT IN would have been a scan because of the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 10:30 am

    #1541983

  • RE: Could not locate file 'SAML' for database 'SAML' in sys.database_files

    Use quotes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 10:22 am

    #1541976

  • RE: DBCC CHECKDB errors

    Nothing drive-related in the Windows event logs (application or system)

    Does that DB's log share a drive with any other?

    Are you running enterprise edition?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 10:21 am

    #1541973

  • RE: DBCC CHECKDB errors

    Any messages about drives being unavailable?

    Anything useful in the SQL error log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 7:13 am

    #1541846

  • RE: Run time Error

    Somewhere you have code that's referencing an object (PARAM) that does not exist. Search through your code and see if you can find it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 6:31 am

    #1541813

  • RE: DBCC CHECKDB errors

    Are there any related messages in the event log?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 6:30 am

    #1541812

  • RE: Index !!!!

    Rebuilding is fine. It's the rest that is the problem. I assume you're not using SQL 2008 (despite posting in the SQL 2008 forums) if that code is already running.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 5:17 am

    #1541787

  • RE: Index !!!!

    Truncating the log = harmful

    Shrinking the log = harmful

    Restarting SQL = waste of time to harmful.

    You also probably don't want to just rebuild all indexes without consideration, and the sampled...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 25, 2012 at 5:07 am

    #1541784

Viewing 15 posts - 16,456 through 16,470 (of 49,552 total)