Forum Replies Created

Viewing 15 posts - 23,941 through 23,955 (of 49,552 total)

  • RE: SQL STACK DUMP

    Check that you're on the latest service pack, if the problem persists call Microsoft's customer support.

    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

    August 25, 2011 at 2:43 am

    #1372996

  • RE: Decryptbykey from inside of a view

    Marios Philippopoulos (8/24/2011)

    What error are you getting?

    Msg 156, Level 15, State 1, Procedure custView, Line 2

    Incorrect syntax near the keyword 'OPEN'.

    Msg 102, Level 15, State 1, Procedure custView, Line...

    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

    August 24, 2011 at 2:30 pm

    #1372826

  • RE: Decryptbykey from inside of a view

    You will have to assume the key is open before the view is queried. A view can only contain a single select statement, nothing else.

    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

    August 24, 2011 at 2:29 pm

    #1372824

  • RE: SQL Server 2008 Upgrade failed

    espanolanthony (8/24/2011)

    when I upgraded I upgraded all the tools also.

    And by the looks of things the database engine upgrade failed and the tools upgrade succeeded. I'd be looking through 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

    August 24, 2011 at 11:35 am

    #1372743

  • RE: Are the posted questions getting worse?

    They haven't been nominated for the Board of Directors, they've been chosen to serve on the nomination committee, the committee that evaluates the nominations for the Board.

    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

    August 24, 2011 at 11:33 am

    #1372741

  • RE: SQL Server 2008 Upgrade failed

    SQLRNNR (8/24/2011)

    If it is causing problems, I would reinstall the tools.

    Otherwise, your database upgrade succeeded.

    Err, the database engine is still 2008 and the tools are 2008 R2.

    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

    August 24, 2011 at 11:31 am

    #1372739

  • RE: Compare two databases

    http://www.red-gate.com/products/sql-development/sql-compare/

    http://www.red-gate.com/products/sql-development/sql-data-compare/

    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

    August 24, 2011 at 9:59 am

    #1372694

  • RE: SQL Server 2008 Upgrade failed

    espanolanthony (8/24/2011)

    But, when I start the SQL serevr I see tat the Product version is still

    10.0.4000.0SP2Standard Edition (64-bit).

    Then either the installation failed or you're looking at the wrong instance

    and...

    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

    August 24, 2011 at 8:52 am

    #1372635

  • RE: SQL Server 2008 Upgrade failed

    espanolanthony (8/24/2011)

    Any one on this please.....

    Patience. We're all volunteers with our own jobs and problems. If you want immediate help, hire someone.

    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

    August 24, 2011 at 8:51 am

    #1372633

  • RE: indexes, when to use include, vs when to use key columns

    As a rather large simplification, yes.

    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

    August 24, 2011 at 8:50 am

    #1372632

  • RE: How to Build a Windows Server 2008 Failover Cluster on Cheap Hardware for a Home Lab

    Coincidentally, this was posted just yesterday

    http://www.sqlskills.com/blogs/jonathan/post/Building-a-Completely-Free-Playground-for-SQL-Server-e28093-(1-of-3)-Downloading-the-Software-and-Setting-up-a-Windows-Server-2008R2-VM-Template.aspx

    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

    August 24, 2011 at 8:46 am

    #1372628

  • RE: Help, my database is corrupt. Now what?

    No. If there's corruption, it'll find it in just about all cases.

    There are odd cases of single-bit corruption of data within a row where the page doesn't have checksum protection,...

    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

    August 24, 2011 at 8:36 am

    #1372617

  • RE: Where the Data is Stored if Select query executed before placing to Grid?

    SQL Server doesn't care what the client does with the data. It'll send the data to the client what happens after that is on the client side and the database...

    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

    August 24, 2011 at 8:18 am

    #1372605

  • RE: Compare two databases

    Please note, this thread is 8 years old.

    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

    August 24, 2011 at 7:43 am

    #1372571

  • RE: "Buffer provided to read column value is too small" Error on SQL 2008 R2

    Have you run CheckDB on the 2008 databases?

    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

    August 24, 2011 at 7:31 am

    #1372557

Viewing 15 posts - 23,941 through 23,955 (of 49,552 total)