Forum Replies Created

Viewing 15 posts - 33,736 through 33,750 (of 49,552 total)

  • RE: Could not find a table or object named 'table'. Check sysobjects.

    Check the settings of 'allow updates' (sp_configure), check the SQL error log to see if that setting was changed recently.

    Don't suppose you know when this started or that you have...

    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

    March 2, 2010 at 8:52 am

    #1127155

  • RE: Indexes

    You might also want to read through this series (3 parts)

    http://www.sqlservercentral.com/articles/Indexing/68439/

    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

    March 2, 2010 at 7:44 am

    #1127100

  • RE: backup job error

    Please post new questions in a new thread. Thank 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

    March 2, 2010 at 7:42 am

    #1127098

  • RE: Could not find a table or object named 'table'. Check sysobjects.

    Has someone been messing around with "Allow Updates" and direct updates to the system tables?

    Check the objects listed in those errors. Are they tables, stored procs, views, functions?

    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

    March 2, 2010 at 7:39 am

    #1127094

  • RE: Could not find a table or object named 'table'. Check sysobjects.

    Ok, firstly, this is not a SQL 2005 server, despite the question being in the SQL 2005 forums.

    Can you also run DBCC CheckCatalog?

    Wouldn't be required on SQL 2005, hence...

    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

    March 2, 2010 at 4:07 am

    #1126943

  • RE: Running SQL Server 32-bit on 64 bit OS

    john.mansfield (3/2/2010)

    Thanks Gail. Does that mean to access the available memory we'll have to make the AWE tweak and be running the SQL Server Enterprise edition? i.e. Standard won't work.

    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

    March 2, 2010 at 4:05 am

    #1126942

  • RE: Could not find a table or object named 'table'. Check sysobjects.

    Please post the full output of the following:

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    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

    March 2, 2010 at 3:39 am

    #1126931

  • RE: Running SQL Server 32-bit on 64 bit OS

    If you use AWE, yes, providing the edition that you have can use more memory than that. Standard (and lower) are limited in what they can use

    Why does the app...

    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

    March 2, 2010 at 3:38 am

    #1126930

  • RE: sql server performance if i have unused storedprocedures or objects.

    Why don't you test it out and let us know if there's a measurable performance impact?

    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

    March 2, 2010 at 3:34 am

    #1126929

  • RE: MCITP 70-441 and 70-442 exams - guidence

    Rather get the 120 (180?) day trial version of Enterprise edition. There's a lot that's not in express. Or you can buy a developer licence (developer edition) for around $50.

    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

    March 2, 2010 at 2:33 am

    #1126903

  • RE: sql server performance if i have unused storedprocedures or objects.

    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

    March 2, 2010 at 1:11 am

    #1126882

  • RE: Whats wrong with this query?

    Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    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

    March 2, 2010 at 1:07 am

    #1126877

  • RE: MCITP 70-441 and 70-442 exams - guidence

    Raghavendra Mudugal (3/1/2010)

    After gaining some experience in the SQL (basically on MSSQL2000), now planning to get my first certification done on SQL 2005 (Database Developer) (70-441 and 442)

    The first exam...

    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

    March 2, 2010 at 1:05 am

    #1126876

  • RE: Reading the .LDF File in Sql server 2005

    Probably. I prefer it, as I can select columns, filter, etc without a temp table.

    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

    March 2, 2010 at 12:59 am

    #1126871

  • RE: Are the posted questions getting worse?

    D.Oc (3/1/2010)

    GilaMonster (3/1/2010)

    No one interested in the soccer world cup?

    Yes, we are very interested in football (soccer) WC

    So, which games are you going 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

    March 1, 2010 at 1:10 pm

    #1126666

Viewing 15 posts - 33,736 through 33,750 (of 49,552 total)