If you have some way of telling SQL the sort order then yes

declare @table table (name varchar(10))

insert into @table values ('Smith'),

('Jack'),

('David'),

('Ellen'),

('john'),

('Peter')

select * from @table order by name asc

select * from...

You will simply just need to query the ingredients table for a sum of the ingredients for the particular recipe that has just been inserted / updated / deleted by...

Is this a homework question by any chance? Also what is the rules behind using a trigger, why not a stored procedure etc? Also what happens should you...

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

You could check the default trace, but that only keeps so much information before it is lost, so highly unlikely that it will be in the trace.

Again custom auditing would...

As you dont have custom auditing in place, finding historic updates/deletes will not be possible.

Look at building custom auditing procedures on the tables you require to know who updated /...

Do you have custom auditing in place?

Do users login with a generic username or do they have their own username?

If the server is in a domain then yes it is recommended, that way should you need to do anything to network shares you can set the correct permissions. ...

Please provide the execution plan of the query along with any indexes which may be on the two tables in question.

A dedicated windows account just for that particular service.

I would suggest some reading material on transaction log management

Stairway to Transaction Log Management - http://www.sqlservercentral.com/stairway/73776/

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/

Why is my transaction log full - http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

Accidental DBA Guide -...

English

You could just query the backupset table and get the space of the backups that way, unless the drive/folders also store none backup files.

We ask for table and data so that we can write a T-SQL statement and test it to ensure that what we do is what your require.

For reference please read...

And now some data?