One more thing: what happens when a row is updated in purchasedetail? Does that quantity have to be updated in products too?

And what happens when you insert a new...

Here is an example that you can use:

-- This is going to be your database

-- I'm using tempdb for this example

USE tempdb;

GO

-- I will create the tables for the sake...

Instead of selecting the MAX(id) and then allocating it by insertin a row with that id, insert the row directly.

As long as it works, you should be fine. Things get compicated...

You'll need to remove any foreign key constraint on the detail table, add a new column with the new primary key on the master table, then update the foreign key...

Sure! Please post table scripts, sample data and expected output. See http://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/ for guidance.

Here is a script that does exactly that: http://www.replicationanswers.com/powershell.asp

You SQL has already been converted to SQL Server: the ssma_oracle.trunc function seems to indicate that you used the SQL Server Migration Assistant (SSMA) for Oracle.

The function is erroring...

The (+) you had in your code seems to suggest thta you're attempting to outer join using the old style join syntax that has been deprecated since forever. Change that...

It groups by filegroup, sothe sum of all files in your case.

You can use my script here: https://spaghettidba.com/2014/09/05/database-free-space-monitoring-the-right-way/

It can be used in a SQL Agent job step, scheduled to run every 5 minutes (or whichever interval is appropriate for you) and...

You're not running the latest build for SQL 2014. You're missing SP2 and CU1. Maybe the fix you're referring to is included in one of those.

I would test in a...

You can always PIVOT your results after splitting. Would that work for you?

You can use a splitter function like this one: http://www.sqlservercentral.com/articles/Tally+Table/72993/

No, sorry, it's not possible. What you want to grant is a database level permission and you'll need to add a user to each database for that, with the appropriate...