Forum Replies Created

Viewing 11 posts - 1 through 11 (of 11 total)

  • Reply To: Trying to deny delete inside a procedure

    GRANT EXECUTE TO exectest
    REVOKE DELETE FROM exectest

    DENY DELETE TO exectest

    SELECT dp.class_desc,
    dp.permission_name,
    dp.state_desc,
    OBJECT_NAME(major_id) as ObjectName,
    grantee.name as Grantee,
    grantor.name as Grantor
    FROM sys.database_permissions dp
    JOIN sys.database_principals grantee
    ON dp.grantee_principal_id = grantee.principal_id
    JOIN sys.database_principals grantor
    ON dp.grantor_principal_id...

    • This reply was modified 4 months, 1 week ago by  morbius82000.
  • RE: How to convert Varbinary(10) to a SSIS variable

    Awesome, just what I was looking for. 🙂

  • RE: Sync Production and Dev

    Grant Fritchey - Friday, January 19, 2018 1:07 PM

    morbius82000 - Friday, January 19, 2018 11:04 AM

    January 19, 2018 at 2:56 pm

    #1976593

  • RE: Sync Production and Dev

    Phil Parkin - Friday, January 19, 2018 2:01 PM

    morbius82000 - Friday, January 19, 2018 1:57 PM

    January 19, 2018 at 2:53 pm

    #1976591

  • RE: Sync Production and Dev

    Phil Parkin - Friday, January 19, 2018 12:15 PM

    morbius82000 - Friday, January 19, 2018 11:04 AM

    January 19, 2018 at 1:57 pm

    #1976585

  • RE: Historical data storage considerations

    To quote our network guy:

    "Transaction logs have heavy sequential write activity while database files have more random read/write activity and thus by setting the Nimble Performance Policy...

  • RE: Sync Production and Dev

    Phil Parkin - Friday, January 19, 2018 10:31 AM

    morbius82000 - Friday, January 19, 2018 10:24 AM

    January 19, 2018 at 11:05 am

    #1976551

  • RE: Sync Production and Dev

    Yes it will synch data if you use a publish script. Redgate works for quick and dirty, but if you want to do it write, use SSDT imho.

  • RE: Sync Production and Dev

    tmmutsetse - Friday, January 19, 2018 7:18 AM

    Hi
    I have a task to make sure that the prod and dev are in snync....

  • RE: SSIS centralization

    In an ideal world, every SQL Server Service should be on it's own server, Reporting Services, Integration Services, Analysis Services and Data Quality Services. This definitely pushes up your licensing...

  • RE: File System Task Variable

    I ran into a similar problem and it seems to have to with the fact that I was using expressions to set my destination and source variables (it's funny because...

Viewing 11 posts - 1 through 11 (of 11 total)