Forum Replies Created

Viewing 15 posts - 91 through 105 (of 130 total)

  • RE: View Permissions

    Thanks for the feedback. I finally set it up with an AD Group called purchasing, and added domain users to that ad group. Then I created a windows authenticated user...

    June 22, 2011 at 7:25 am

    #1342366

  • RE: View Permissions

    Michael L John (6/20/2011)

    It may be a bit cleaner to add (or create) the Active Directory group that corresponds to the purchasing department to SQL Server, and grant execute to...

    June 20, 2011 at 4:04 pm

    #1341497

  • RE: View Permissions

    Nevermind. I got it with Revoke Select ON....

    June 20, 2011 at 3:34 pm

    #1341483

  • RE: View Permissions

    RP_DBA (6/20/2011)

    You should just have to grant them access to the db and then grant them select permissions on the view.

    USE [DATABASE]

    GO

    CREATE USER FOR LOGIN

    GO

    GRANT SELECT ON [SCHEMA].[VIEW]...

    June 20, 2011 at 3:32 pm

    #1341481

  • RE: What makes a database transactional?

    Another question I have is on what actually gets replicated. Are just tables typically replicated in either transaction or merge replication or do entire databases get replicated?

    What have some of...

    June 20, 2011 at 1:06 pm

    #1341410

  • RE: What makes a database transactional?

    Meredith Ryan-Smith (6/9/2011)

    you definitely want to do any changes like setting up replication in a test environment. I can tell you that I use transactional replication with my very...

    June 15, 2011 at 8:30 am

    #1339016

  • RE: Update a record based on another record

    Sean Lange (6/9/2011)

    fyi, you can run SELECT * FROM fn_helpcollations() to view all the available collations.

    Thanks Sean. I ran it and saw 2397 different collations. I looked at the database...

    June 15, 2011 at 8:19 am

    #1339007

  • RE: Update a record based on another record

    Sean Lange (6/8/2011)

    Sriram.RM (6/7/2011)

    you can use Upper()/Lower() function to overcome issues related case sensitive issues or look at collation...

    those functions won't help you unless you are in a case...

    June 9, 2011 at 12:54 pm

    #1336648

  • RE: What makes a database transactional?

    GilaMonster (6/8/2011)

    Transactional replication works in all recovery models.

    I suppose the best thing to do would be to test it in a test environment and see how it goes. We...

    June 9, 2011 at 12:48 pm

    #1336644

  • RE: Using SSIS for FTP and Email

    GSquared (6/8/2011)

    You can use expressions to pull specific file names.

    How familiar are you with the FTP standard? The SSIS FTP task is pretty standard on those points.

    I am familiar...

    June 8, 2011 at 7:45 am

    #1335656

  • RE: What makes a database transactional?

    andersg98 (6/7/2011)

    Transactions are individual items of work in a database. Generally RDMS implementations use transaction support to achieve the ACID principle. That is, every unit of work must...

    June 8, 2011 at 7:22 am

    #1335642

  • RE: What makes a database transactional?

    GilaMonster (6/7/2011)

    kwoznica (6/7/2011)

    Would it then be safe to say that as long as a database is in full recovery mode it can be used for replication?

    No.

    Recovery model and replication...

    June 8, 2011 at 7:08 am

    #1335626

  • RE: What makes a database transactional?

    PaulB-TheOneAndOnly (6/7/2011)

    kwoznica (6/7/2011)

    If a database is in full recovery mode is it technically transacational? After all data is sent to transaction logs.

    Or does the application code need to specify...

    June 7, 2011 at 4:51 pm

    #1335396

  • RE: Using SSIS for FTP and Email

    GSquared (6/7/2011)

    SSIS has a built-in FTP task operator. It won't work with SFTP ("Secure" FTP), but if it's vanilla FTP, it should be able to do what you need....

    June 7, 2011 at 2:42 pm

    #1335339

  • RE: Update a record based on another record

    That worked perfectly. The only hiccup was finding that the name needs to be upper case. Not sure how to work around case sensitivity.

    Otherwise that will easily save me...

    June 7, 2011 at 9:17 am

    #1335084

Viewing 15 posts - 91 through 105 (of 130 total)