Forum Replies Created

Viewing 15 posts - 736 through 750 (of 1,319 total)

  • RE: Table not showing PK - PK is in sysindexes ?

    I'll be darned. :blush: Learned something new today! I've used my script for so long, never tried to find a better (easier) way to do it. Thanks.

    -- You can't be late until you show up.

  • RE: Steps to take by fresher in DBA field?

    Thank you SA. My recommendation, to expand on it a bit, was not meant to be a blow-off of your quest for help. The biggest thing you can do is...

    -- You can't be late until you show up.

  • RE: taking sql server backup on different machine

    Why are you trying to do this? The preferred method would be to backup local and then copy the backup file to a network share. It can be done using...

    -- You can't be late until you show up.

  • RE: Steps to take by fresher in DBA field?

    Learn to use search engines. I just did a simple search here and found this as the first article. Also, have you looked through BOL??

    http://www.sqlservercentral.com/articles/career+growth/64632/

    Edit: here is another post to...

    -- You can't be late until you show up.

  • RE: Table not showing PK - PK is in sysindexes ?

    arr.nagaraj (3/18/2009)


    select object_name(id) from sysindexes where name like ''

    While this definitely will work, it won't provide the table name that the index is associated with. In an earlier post I...

    -- You can't be late until you show up.

  • RE: T-SQL - SELECT TOP

    I too selected the most accurate, albeit incomplete, answer.

    dmw (3/18/2009)


    Poor (non-existent?) QA on this question. Unexpected from this site.

    I couldn't agree more but I'm sure with the volume of...

    -- You can't be late until you show up.

  • RE: T-Sql rant

    Gaby Abed (3/16/2009)


    Why do I suspect that we're slowly being led to a point where he wants us to solve an actual problem at work, rather than just a general...

    -- You can't be late until you show up.

  • RE: Table not showing PK - PK is in sysindexes ?

    Something like this. Keep in mind, I use this is SQL 2000 and it will need to be tweaked for 2005/2008. Modify the like clause to suit your needs.

    select ...

    -- You can't be late until you show up.

  • RE: Table not showing PK - PK is in sysindexes ?

    I'll bet that index exists on a different table. I've got a script at home to find indexes and the associated table. If noone has supplied it to you by...

    -- You can't be late until you show up.

  • RE: Not a suggestion per se but wasn't sure what forum to use

    DOH! I jumped right into the article after glossing over the title. I should have realized it when it stated Lynn was a "new author"... from now on I gotta...

    -- You can't be late until you show up.

  • RE: Datetime - find records that are created in a date/time range

    GSquared (3/12/2009)


    You seem to have deleted the original question and all its specifications.

    Very poor forum etiquette -don't you think newB?

    -- You can't be late until you show up.

  • RE: Shared Directory

    If I understand your request correctly, the file share physically resides on your SQL server box, correct? And your stored procs refer to \\servername\..., which is the local box? If...

    -- You can't be late until you show up.

  • RE: Are the posted questions getting worse?

    You mean we don't get PAID? I'm so out of here.....;)

    -- You can't be late until you show up.

  • RE: Lets help the experts help themselves

    george sibbald (3/7/2009)


    t.walker (3/6/2009)


    I really support that idea. I think a more private invited members forum would enable me to speak more freely/

    Although I am a rookie here, I am...

    -- You can't be late until you show up.

  • RE: Database recovery

    amarnath_sk (3/9/2009)


    It dose not depend on which recovery mode, which you have kept.

    I didn't think that was even an issue. The issue is about the recovery of the database, not...

    -- You can't be late until you show up.

Viewing 15 posts - 736 through 750 (of 1,319 total)