Forum Replies Created

Viewing 15 posts - 166 through 180 (of 296 total)

  • RE: Two Factor Authentication

    GSquared (8/24/2009)


    I think this would be a good option for high-security systems. I don't think it will fly in most small businesses.

    Some of this depends on the regulatory requirements...

  • RE: Two Factor Authentication

    JohnMagnabosco (8/24/2009)


    In SS2008 there is the Auditing feature. You can document activities that occur on the database through that option.

    The question is whether certain IDs can elimiante records related to...

  • RE: Installing Query Tool for Various Users

    2 Tim 3:16 (7/31/2009)


    Also, if their sharp enough, they can download their own copy of SQL Express with Advanced Services for free (which includes SSMS).

    That depends on the group policies...

  • RE: Msg 8152, Sev 16: String or binary data would be truncated. [SQLSTATE 22001]

    There's no real easy way to find the data that's too long. I usually look at each cloumn from the source and make sure that the receiver columns are appropriately...

  • RE: file transfer ideas...

    We use robocopy for many filecopy operations. It works well across the WAN, and is pretty robust. I understand it's easy to automate as well. It's available from Microsoft.

  • RE: Corporate Hackers

    I think much of the internal hacking comes from inadequately defining the controls environment for our applications, leaving security concerns for the last minute. Assessing the risks of an application...

  • RE: Help With a Cursor Please

    I'll second that belief that non-database programmers who try to use SQL overuse cursors. I support a vendor provided app, and have spent copious amounts of time beating on the...

  • RE: Limit users with Management Studio Accessing a DB

    Free (7/6/2009)


    Hi there

    Bit of legacy app and has been around for like 10 years.. Not too sure why it was designed like this.

    I've seen several apps that were developed in...

  • RE: Limit users with Management Studio Accessing a DB

    I would also question how you prevent users from using Access and ODBC to make changes to tables directly. This is one reason we do all of our updates via...

  • RE: Get current user from Active Directory through t-Sql

    Host name is also useless if your users connect from a terminal server session. All of th eusers on the same TS will ahve the same host name.

  • RE: Should login names and users names be the same?

    If you have a number of users who need the same access, you can create an NT group and give the acces son SQL Server to the group, which is...

  • RE: Vendor Value

    blandry (5/18/2009)


    Maintenance fees in software, like credit cards, is simply a form of robbery with a nice name. Either the whole concept should just be illegal, or we should...

  • RE: I've tried this on 2 other forums, does anyone know the answer?

    I would go with the separate databases myself. It's much easier to me to manage access by database thant to control access to a single database by 13 different locations...

  • RE: Vendor Value

    I think maintenance is something that is very dependent on the purpose of the application. I wouldn't pay maintenance on basic office software, but am perfectly willing to pay it...

  • RE: The Rights for Data

    So the authors want me to pay for rights to read a book on a Kindle, and then pay more to have the Kindle read the book to me? That's...

Viewing 15 posts - 166 through 180 (of 296 total)