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 years, 5 months ago by  morbius82000.

Awesome, just what I was looking for. 🙂

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...

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.

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...

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...