role permissions are cumulative, so if you have anNT user in two roles, one with readwrite, and one with read only, the effective permissions are the sum....readwrite.
only an explicit...

yes of course; what you want is to create a role. assign specific permissions to the role,and then add the users to the role, regardless of whether they are SQL...

if you've added any windows_groups, it's still possible that users have access, and have database access, because they login thru group membership,but don't have an explicit login.

here's a...

Sue_H identified the other part of your issue(permissions to fiddle with the registry) : you must run Powershell as Administrator...right click...run as Administrator.

because you have not used powershell before, you have to do what the error says and set the execution policy.

run this command, and then re-run your script.

that script will drop all temp tables your session actually created;but not global temp tables that are in scope.
it would be handy for testing the guts of a stored...

This script from Microsoft Script Center worked flawlessly for me:
https://gallery.technet.microsoft.com/scriptcenter/ImportExport-projects-bca5f29f

I had to change the connection string from localhost to my real servername. I could potentially change the...

he's casting to INT2, which is IBM's as400/DB2/Universe? smallint equivalent i think.
the logic Phil identified is still the same though, cast to bigint INT8/ and see what is...

adpr0401 i've seen the same issue multiple times since the last...

use powershell, it will be easier;
i googled "powershell export ssis package from integration services catalog" and the first four script hits  all look familiar enough to work for you.

tables and views are easyto convert, but procedures that do stuff meta-data wise will require a complete re-write.
checkdb? kind of equivalents are CHECK TABLE , REPAIR TABLE , ANALYZE TABLE 
reindex? backup and...

i run something like this that installs all my standard scripts on a given server.
you are really asking how can i add an outer loop to this, so ii...

this linky shows how you can peel the orange with a chainsaw:
instead of simply downloading all the projects and using a text editor to search the *.dtsx files, this...