Looking at your code I am not even sure what it is you are trying to accomplish.

My car sounds funny, what's wrong with it?

Basically, that is what...

I found an extraneous ( where a MAX function is being called.  After deleting that extra ( I was able to format the code using SQL Prompt.

And perhaps this? http://www.sqlservercentral.com/articles/Stairway+Series/134672/

Does this help? http://www.sqlservercentral.com/scripts/PowerShell/167128/

The system doesn't store who did the creates of the objects.  You will need to setup audit(s) to capture that information.  This information may (again, may) be in the default...

One way to do it:

CREATE TABLE #tmpdata(MyDate INT, MyTime INT);

INSERT INTO [#tmpdata]([MyDate],[MyTime])
VALUES (20180209,161517),(20180209,164505);

SELECT
  [t].[MyDate]
  , [t].[MyTime]
  , STUFF(STUFF(CONVERT(VARCHAR(8), [t].[MyDate]),7,0,'-'),5,0,'-') + ' '...

MyTable, YourTable, still don't see the table in either query.  So what is the problem?

And posting in a bigger font doesn't help.