Forum Replies Created

Viewing 15 posts - 41,836 through 41,850 (of 49,552 total)

  • RE: KERBEROS

    This has nothing to do with Kerberos. The error is saying that either the table that you're querying does not exist, or the user that you're connecting across the linked...

    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 9, 2009 at 1:44 pm

    #924560

  • RE: Sql QUERY Help

    Great, we've got table structure and sample data.

    Based on the sample data you have posted, what are the exact results that you want? Post exactly what values you need 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

    January 9, 2009 at 1:29 pm

    #924546

  • RE: Restore Database Without Log

    Tim Riley (1/9/2009)

    When I try to restore the database I get a message that an error was encountered processing the log file. The message says to either restore from...

    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 9, 2009 at 1:22 pm

    #924540

  • RE: Are the posted questions getting worse?

    Grant Fritchey (1/9/2009)

    GilaMonster (1/9/2009)

    I'm actually the other way around. The heat just kills me. Day after day of this and I can barely even think, just want to sit in...

    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 9, 2009 at 1:14 pm

    #924536

  • RE: Are the posted questions getting worse?

    DavidB (1/9/2009)

    Maybe if you just post the link to the article about how to effectively post the OP will eventually get it. Maybe a bit like Tennis for while but...

    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 9, 2009 at 1:12 pm

    #924535

  • RE: Resource Governor

    lucassouzace (1/9/2009)

    What´s Diference between SUSER_SNAME and APP_NAME using Resource Governor?

    SUser_Sname returns the user's login name. App_name returns the application that initiated the connection to SQL. In terms of the resource...

    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 9, 2009 at 1:10 pm

    #924533

  • RE: data block

    vishudata (1/9/2009)

    Write an SQL query if you want to select the data from one block which intern reflects in another block?

    Um... That question makes absolutely no sense. Could you perhaps...

    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 9, 2009 at 1:08 pm

    #924531

  • RE: Are the posted questions getting worse?

    Michael Earl (1/9/2009)

    GilaMonster (1/9/2009)

    Hmmm.

    http://www.sqlservercentral.com/Forums/Topic633720-338-1.aspx

    I like how the OP re-stated the same non-question. Perhaps it should have been in bold the second time.

    There seems to be an echo in...

    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 9, 2009 at 1:03 pm

    #924523

  • RE: Sql QUERY Help

    Did you read the link that I and several other people posted?

    Based on the sample data that you gave, what are the exact results that you want?

    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 9, 2009 at 1:01 pm

    #924521

  • RE: Error: 5243, Severity: 22, State: 1

    I would suggest you call Microsoft's customer support for this one. We don't have the tools or knowledge to interpret a stack dump

    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 9, 2009 at 1:01 pm

    #924520

  • RE: Are the posted questions getting worse?

    Hmmm.

    http://www.sqlservercentral.com/Forums/Topic633720-338-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 9, 2009 at 12:43 pm

    #924501

  • RE: Sql QUERY Help

    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 9, 2009 at 12:39 pm

    #924500

  • RE: Error: 5243, Severity: 22, State: 1

    Please post the full error message, the exact version of SQL that you are on and what seems to cause the error.

    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 9, 2009 at 12:38 pm

    #924498

  • RE: How big will the transaction logs get?

    Steve Jones - Editor (1/9/2009)

    There's no downside to doing this. Change it during the day, set up backups every 15 minutes and keep track of the sizes. Set an outlook...

    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 9, 2009 at 12:36 pm

    #924496

  • RE: SSIS a pain and Openrowset is disabled no access for linked...

    JPLeBlanc (1/9/2009)

    I have attempted this, but who knows if i was doing it correctly or not, do you all know of any specific learning courses for the workflow editor? or...

    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 9, 2009 at 9:00 am

    #924276

Viewing 15 posts - 41,836 through 41,850 (of 49,552 total)