Forum Replies Created

Viewing 8 posts - 1 through 9 (of 9 total)

  • RE: ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum

    Thanks for your efforts. I appreciate how generous you have been with your time; and for free, no less.

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

  • RE: ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum

    Allow me to clarify what I am looking for.

    Setting or resetting the ANSI_PADDING value of the connection is simple enough, as you have pointed out.

    For replication, it is necessary for...

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

  • RE: ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum

    Thanks for the reply.

    I assumed that the sys.tables.uses_ansi_nulls represented the SET ANSI_NULLS setting. BOL seems to indicate that it is. I just can't find any place where the...

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

  • RE: ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum

    Useful information; thank-you.

    What I am trying to determine, after running into various ANSI_PADDING errors in replication, is which tables currently have the ANSI_PADDING set on. I'd like to be...

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

  • RE: Demo of DBA stuff

    "Plagiarism" "Rip-off"

    I couldn't disagree more. The point of having a support network, such as this site, is to be able to leverage the existing knowledge and scripts and, in...

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

  • RE: log_reuse_wait_desc = replication but there's no replication

    Thank-you, Gail. you were exactly right that this was a restore of another server's database. I ran the publish/remove publish and all is well again. Not bad...

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

  • RE: T-SQL Function to Determine Holidays in SQL Server

    Some meaningful variable names would go a long way toward making this readable.

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

  • RE: Find Column Usage

    Does the script account for the possibility that the column name might cross a syscomments boundary (e.g., Part of the column name is at the end of syscomments.Row1 while the...

    ============================================================
    I believe I found the missing link between animal and civilized man. It is us. -Konrad Lorenz, Nobel laureate (1903-1989)

Viewing 8 posts - 1 through 9 (of 9 total)