Forum Replies Created

Viewing 15 posts - 211 through 225 (of 758 total)

  • RE: The database principal owns objects in the database and cannot be dropped

    zhazhuzhao (5/5/2013)


    SQLSACT (5/3/2013)


    Can't remember where I found it, use this script to determine which objects are owned by the user

    ;with objects_cte as

    (

    select

    ...

  • RE: The database principal owns objects in the database and cannot be dropped

    Can't remember where I found it, use this script to determine which objects are owned by the user

    ;with objects_cte as

    (

    select

    ...

  • RE: Lock request time out period exceeded. (Microsoft SQL Server, Error: 1222)

    What is the SPID the rollback in running under?

    What is the output of sp_lock spid ?

  • RE: Rebuild or DBREINDEX

    alistair.mc14 (4/30/2013)


    if you have a table that has a clustered index and non-clustered index(es), bear in mind that the non-clustered index use pointers to the clustered index key, to locate...

  • Viewing 15 posts - 211 through 225 (of 758 total)