Forum Replies Created

Viewing 15 posts - 34,621 through 34,635 (of 49,552 total)

  • RE: Database Integrity Error

    Then the failure was from one of the later tasks. You need to log the output of the maintenance plan to tell exactly where.

    btw, why on earth are you both...

    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

    January 18, 2010 at 9:17 am

    #1104996

  • RE: problem restoring MSDB

    SQL Noob (1/18/2010)

    is it possible to restore a SQL 2000 msdb backup on to a sql 2005 server?

    I wouldn't recommend it. Not for any of the system 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

    January 18, 2010 at 9:11 am

    #1104989

  • RE: combine NLB and database mirroring

    mstephens1754 (1/18/2010)

    Ok do you use NLB with the mirroring if not the only way you can reconnect sharepoint during a failure is through the use of a sql server alias.

    Not...

    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

    January 18, 2010 at 9:08 am

    #1104983

  • RE: Database Integrity Error

    What's in the error log? CheckDB results are logged to the error log, so you should be able to see what ran.

    Do you have the maint plan logging output 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

    January 18, 2010 at 8:35 am

    #1104975

  • RE: Added CPU but not seeing it in server properties

    Does the operating system see the CPU?

    Have you rebooted since adding the CPU? I don't think that 2005 standard edition supports hot-add of processors.

    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

    January 18, 2010 at 8:34 am

    #1104971

  • RE: how to save "application form" in the database

    I'm going to give unpopular advice.

    Store the data in a properly normalised table design, with each piece of data in a column with an appropriate data type, tables fully normalised...

    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

    January 18, 2010 at 8:01 am

    #1104949

  • RE: How do I downgrade from SQL 2008 Std to 2005 Std?

    Pierre M. Camilleri (1/18/2010)

    So how can I do an SQL Server 2005 Std installation using this cd?

    You can't. If I recall (and this needs to be checked preferably with Microsoft),...

    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

    January 18, 2010 at 7:55 am

    #1104947

  • RE: how to retrive row id from a table

    amitsingh308 (1/18/2010)

    now i need to fetch the record id of this table can any one tell me how can i do so

    What exactly do you mean by Record ID? What...

    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

    January 18, 2010 at 7:49 am

    #1104943

  • RE: Deadlock Scenario

    kingscriber (1/18/2010)

    What I think you are trying to get me to see is that isolation level and lockModes are two different "entities". However they do effect each other, but not...

    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

    January 18, 2010 at 7:49 am

    #1104942

  • RE: Create Table in stored proc

    Sure I can.

    I assume you're not just asking if I can, but would like said explanation? 😉

    Whenever a DDL statement is executed in a batch, the execution...

    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

    January 18, 2010 at 7:43 am

    #1104937

  • RE: How do I downgrade from SQL 2008 Std to 2005 Std?

    Never heard of a downgrade option, I'd just uninstall SQL 2008 and install SQL 2005. Honestly, that portion is the least of your problems.

    The biggest problem here is that there's...

    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

    January 18, 2010 at 7:38 am

    #1104932

  • RE: How do I downgrade from SQL 2008 Std to 2005 Std?

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic849141-391-1.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

    January 18, 2010 at 7:35 am

    #1104929

  • RE: Create Table in stored proc

    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

    January 18, 2010 at 7:32 am

    #1104928

  • RE: Need confirm this problem

    shanu.hoosen (1/18/2010)

    The answer is simple. you do have a clustered index(Primary Key) on the key column. SQL will store data based on this column.

    If i have to alter your create...

    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

    January 18, 2010 at 7:26 am

    #1104926

  • RE: Column and Row Total

    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

    January 18, 2010 at 7:07 am

    #1104915

Viewing 15 posts - 34,621 through 34,635 (of 49,552 total)