Followup:

If anyone needs the answer to this - I changed my methodology by adding a record to a tracking table setup specifically for this purpose and used a maintenance job...

Ah ha - thank you Gail. That was a rather silly mistake!

The code worked great, the trigger has been created. Except now when the application creates a new...

Well, I was able to get everything working up to adding the actual trigger...

When I fire off the code to create the trigger (below), I receive the errors:

"

Msg 102, Level...

Currently I add each .ndf file by hand (two of them) to spread the datafiles across multiple drives on the server. Given the databases are created by our operations...