Why do people think it's funny for their SA account to have  a simple password, and for it to be stored in plain text in the DDL of an object......

I really hope you aren't connecting as the sa, and that isn't your password.

Will SSIS populate tempdb as it does transformations within the Dataflow? No, SSIS doesn't use the resources of the Data Engine, it uses it own. Will that effect the performance...

I'm confused, in all honestly. If someone has permission to CREATE objects on a database, and you are auditing events which include creating objects, then they should inherently have access...

For things like this, you should be having a read of the documentation first; you'll find you learn more if you do the research yourself. This one, however,...

Thanks Steve, that's much more what I was getting up with the table design.

TheFirstOne, please try to put your code in code BBcode markup; it's makes your...

I had no luck either I'm afraid Eirikur. It seems that, at the moment, SQL Server 2017 on Linux doesn't support OpenSSL 1.1.0g (which is odd, as to me that's...

Ensure you set your page margins to exactly size of whatever one page is, ensure you set your page size to that size as well (i can't recall what the...

This is actually a duplicate: https://www.sqlservercentral.com/Forums/1934592/Script-out-all-permissions-across-all-databases-for-a-specific-user

Ok, let's start with the first bullet point: A query to create all the tables(QCreateTables).This implies you have DDL for your table(s). Could you post that please? We then know...

The SSIS tools are in the SSIS Toolbox Pane, not the Toolbox Pane.

You can't SELECT from a Stored Procedure. If you need to insert the results from an SP into a table you must first create the table with the correct definition,...

If you mean are there any "breaking changes" from SQL Server 2008R2 to SQL Server 2016? Yes, there are:
SQL Server 2012: https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2012/ms143179(v=sql.110)
SQL Server 2016: