Forum Replies Created

Viewing 15 posts - 5,836 through 5,850 (of 39,870 total)

  • RE: Context_info() data

    drew.allen - Tuesday, February 13, 2018 9:39 AM

    But the explanation says "SET CONTEXT_INFO needs varbinary(128) data passed in."  In other words,...

  • RE: Production Scripts

    Eric,

    Do you track some logins, Linked servers, with this as well? Those server level objects are often just maintained by DBAs, but easy to forget that audits,...

  • RE: Production Scripts

    Eric M Russell - Tuesday, February 13, 2018 7:59 AM

    Jobs are something that tends to get modified in production without going through...

  • RE: Production Scripts

    Stefan LG - Monday, February 12, 2018 9:32 PM

    I have not really thought about source control SQL Agent jobs with a VCS...

  • RE: Cloud Safe

    robert.sterbal 56890 - Tuesday, February 13, 2018 6:11 AM

    That was acronym soup. I'd suggest Point in Time (PIT) instead of just PIT,...

  • RE: Context_info() data

    TUellner - Tuesday, February 13, 2018 9:09 AM

    According to the Microsoft docs you can pass binary or a constant that is implicitly...

  • RE: Production Scripts

    The people that I know doing this with a VCS, write code in an idempotent where. There is a wrapper to check for the job and create/alter it. They often...

  • RE: Why can't I paste SQL code into a post???

    Interesting. I primarily post in FF and Chrome. Never use Edge. I've seen weirdness on too many sites.

  • RE: Are the posted questions getting worse?

    drew.allen - Monday, February 12, 2018 9:24 AM

    Another example of people not supplying nearly enough information.  I got an email from someone...

  • RE: Getting the Data Back

    THanks, glad you like it

  • RE: Why can't I paste SQL code into a post???

    What browser are you using? Are there any strange characters in the post?

  • RE: Row-level security for users belonging to multiple AD groups?

    That might help. Maybe use a CASE and return a 1 when IS_MEMBER() works in either case, or nothing otherwise.

  • RE: Why can't I paste SQL code into a post???

    Either way should work. I sometimes put the tags in, then the code. Sometimes the other way. Both seem to work, and occasionally, both fail miserably.

    The entire editor...

  • RE: New Rules

    Definitely deprecated, but I know there are systems using these and you might run into an older, or upgraded, system. Hence my decision to build a few questions.

  • RE: Are the posted questions getting worse?

    drew.allen - Friday, February 9, 2018 11:16 AM

    Why do so many people think that "it doesn't work for me" is a sufficient...

Viewing 15 posts - 5,836 through 5,850 (of 39,870 total)