Forum Replies Created

Viewing 15 posts - 5,026 through 5,040 (of 14,953 total)

  • RE: Where do you look for DBA's?

    At 11 pages, it better have a better plot, more engaging bad guy, and a more exciting hero, than most resumes I've read! 🙂

  • RE: Are the posted questions getting worse?

    newdb (2/10/2011)


    Yes I agree that some of the question posted - you can get the answer from BOL or from other posts, but on the other hand I can understand...

  • RE: SSMS Not installing

    In the installation options, did you make sure Client Tools included SSMS? Does your installation media include that option?

  • RE: Are the posted questions getting worse?

    Kit G (2/9/2011)


    To those Threadzians (and everyone else) getting hit by the latest winter storm, stay warm and safe.

    And to those in Florida who can't deal with frigid, sub-70 Farenheit...

  • RE: Maintaining Parallel environments

    It's not easy, and not practical.

    Here's the simplest reason why: If you add a new column to PreProd (what most would call Dev), how does the data in that stay...

  • RE: Evaluation/Free version of SQL?

    Evaluation Edition is Enterprise and stops working after something like 6 months.

    Express Edition is free, but has limits on what it can do. If the class covers features it...

  • RE: Force Package not to fail

    It'll depend on what you're trying to do and what error(s) you're getting.

    If, for example, you want the package to "succeed" even if it's unable to connect to any servers...

  • RE: Membership Database schema incl. 12 monthly renewals

    Jack Corbett (2/9/2011)


    I probably wouldn't use a view because I like to use SP's for all data access so the query would just go in the SP as is, but...

  • RE: Export Sysusers table from all databases to flat file?

    Check out Red Gate's Multiscript product (link at top of the page).

    Otherwise, take a look at sp_MSForEachDB. That'll probably get you most of the way there.

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (2/9/2011)


    GSquared (2/9/2011)


    Stefan Krzywicki (2/9/2011)


    GSquared (2/9/2011)That and the thread on "Where do you find DBAs" have made me wonder more about how managers pick DBAs. I know how...

  • RE: Password expired and Deactivate logon Id

    There's probably a way to do it through policy management.

    You might be able to get "good enough" by just querying sys.sql_logins. The modify date updates if the data is...

  • RE: Database Mail not being sent

    Have you checked the db mail tables in msdb? I find looking in those tremendously helpful for oddball issues with that feature.

  • RE: Changing db owner script

    I'll recommend Red Gate's Multiscript product for that kind of thing.

    If you can't get that (check the link at the top of this site), then a dynamic SQL script that...

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/9/2011)


    jcrawf02 (2/9/2011)


    Anybody have suggestions (blog/thread/article/advice) for me on how to find whether a value in one column contains a value in a different table's column?

    Currently I'm doing...

  • RE: Are the posted questions getting worse?

    GilaMonster (2/9/2011)


    ALZDBA (2/9/2011)


    GilaMonster (2/9/2011)


    ...

    To put things in context, my desktop (which I'll be using for this) blue screened this morning then, on reboot failed POST repeatedly.

    Am hoping it's a once-off,...

Viewing 15 posts - 5,026 through 5,040 (of 14,953 total)