Forum Replies Created

Viewing 15 posts - 28,831 through 28,845 (of 49,552 total)

  • RE: I Can't Attach an MDF, on SQL MANAGER 2005 (HELP)

    GilaMonster (12/16/2010)

    Text of the errors please. I'm not downloading 5MB of images just to see a couple hundred bytes of test data.

    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

    December 16, 2010 at 2:54 pm

    #1263753

  • RE: I Can't Attach an MDF, on SQL MANAGER 2005 (HELP)

    Text of the errors please. I'm not downloading 5MB of images just to see a couple hundred bytes of test data.

    Do you have a backup?

    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

    December 16, 2010 at 2:29 pm

    #1263737

  • RE: Scope of sp_executesql

    Ownership chaining. Dynamic SQL of any form break that. Hence the 'permissions on base table' requirement if using any form of dynamic 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

    December 16, 2010 at 2:22 pm

    #1263733

  • RE: Transaction Log Issues Continue, even after backups and transaction log 'backup' jobs, help!

    Because sometimes when the DB is in the half-replicated state, that fails with an error saying that the DB is not replicated.

    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

    December 16, 2010 at 2:21 pm

    #1263731

  • RE: Bit Data Type

    ronaldkrex (12/16/2010)

    Yes I did open it in the SSMS and selected edit top #### rows. Thanks for your help.

    That's written in .net, and it casts the bit to the .net...

    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

    December 16, 2010 at 2:17 pm

    #1263727

  • RE: I Can't Attach an MDF, on SQL MANAGER 2005 (HELP)

    What's the exact error when you try to attach?

    Let me guess, no backup?

    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

    December 16, 2010 at 2:02 pm

    #1263719

  • RE: Bit Data Type

    Don't use the Edit Rows grid, it's broken in several ways (this being one of them). If you want to see rows, use a select query. If you want to...

    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

    December 16, 2010 at 2:01 pm

    #1263717

  • RE: Transaction Log Issues Continue, even after backups and transaction log 'backup' jobs, help!

    No idea. I've seen it on everything from 2000-2008. Sometimes caused by restoring a published database to server without replication configured. Rest of time I haven't been able to figure...

    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

    December 16, 2010 at 1:50 pm

    #1263711

  • RE: DDL Trigger

    You don't say what DDL events you're looking at, but if the trigger is on ALL_DDL_EVENTS (or similar), update stats will trigger that. Suggest you exclude that event from 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

    December 16, 2010 at 1:42 pm

    #1263705

  • RE: Transaction Log Issues Continue, even after backups and transaction log 'backup' jobs, help!

    1) Create a transactional replication publication. Publish a single article (a small one)

    2) Stop the log reader job

    3) Run the same repldone command you ran earlier

    4) Delete the publication that...

    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

    December 16, 2010 at 1:24 pm

    #1263686

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/16/2010)

    I know I'm biased, but I really do like SQL Prompt and the way it works. I think SSMS intelisence is a good idea, poorly executed.

    Likewise. 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

    December 16, 2010 at 1:04 pm

    #1263672

  • RE: Transaction Log Issues Continue, even after backups and transaction log 'backup' jobs, help!

    jasonnance77 (12/16/2010)

    Your comment made me think a little differently about this. I queried the sys.databases table and looked at the log_reuse_wait_desc column, it stated REPLICATION. I have NO...

    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

    December 16, 2010 at 1:00 pm

    #1263666

  • RE: Transaction Log Issues Continue, even after backups and transaction log 'backup' jobs, help!

    Rich-403221 (12/16/2010)

    First, you don't mention if you are doing the log backup with truncation. If not, then all transactions will remain, as the default is without truncate.

    Err, no. 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

    December 16, 2010 at 10:10 am

    #1263561

  • RE: Transaction Log Issues Continue, even after backups and transaction log 'backup' jobs, help!

    jasonnance77 (12/16/2010)

    Replicated Transaction Information:

    Oldest distributed LSN : (0:0:0)

    Oldest non-distributed LSN...

    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

    December 16, 2010 at 10:07 am

    #1263559

  • RE: Bit Data Type

    Bit fields store 1 or 0. In SQL 2008, 'true' is implicitly converted to 1 and 'false' to 0, but the field does not actually store 'true' or 'false'

    Are you...

    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

    December 16, 2010 at 10:04 am

    #1263558

Viewing 15 posts - 28,831 through 28,845 (of 49,552 total)