My opinion, that is one of those "it depends" problems.  Is the timeout in code execution OR is the timeout in the connection?

If the timeout is in code execution, do...

I think in this case "best" is a relative term.

There are several ways to do it.  long character separated string values, key value pairs, very wide tables with non-descript column...

It depends entirely on the language you are working with.  As this is SQL Server Central, I am assuming you are working in SQL Server.

The way I would do this...

As a thought... I wonder if MAYBE the user is a member of a group that has deny permissions on a system object but you also granted the permissions explicitly.

What...

We use it to transfer realtime data from one system to another.  Mostly as a way to break reliance on linked servers where possible.

We pull data from system X into...

how about this:

CAST(xmldata.value('(ns8:date)[1]','DATETIMEOFFSET') AS DATE) AS RDATE

Basically get the value in it's original format (DATETIMEOFFSET) and then cast that to a DATE.

You are missing an "END" after your BEGIN.

Putting in the restriction on delete isn't a bad idea, but depending on the permissions the user is granted, it may not be enough.  what if they drop that trigger? ...

I should add that there is a little bit of risk with SQL injection depending on what is in the code.

For example, the Query that is being executed is:

            
May 24, 2019 at 3:51 pm
            
#3647033

            
            
                                                
        

This may not be the most elegant solution, but I believe it should work for you.  Just need to un-comment the EXEC(@SQLCMD) line:

DECLARE @SQLCMD VARCHAR(MAX) = '';
DECLARE...

• This reply was modified 6 years, 7 months ago by Mr. Brian Gale.
• This reply was modified 6 years, 7 months ago by Mr. Brian Gale.

Quick fix:

In the line "SET @SQLQuery", try casting your @intID to an NVARCHAR(255).

EDIT - re-read your post and I see you tried this already.  Is it giving the same error...

• This reply was modified 6 years, 7 months ago by Mr. Brian Gale.
• This reply was modified 6 years, 7 months ago by Mr. Brian Gale.

Can you post your query?

Looking at the screenshots the first result set shows row 91 and the second result set shows row 1.  Since no row in data set 2...

As a crazy thought, what happens if you try opening the error log file outside of SQL?  With the new instance you can shut it down and have a look...

Welcome to the forum and to SQL Server!

So looking at your queries, my understanding is the first one is adding columns to an already existing table.  That one looks good...

I have been working as a DBA for about 8 years (roughly) and I don't see the "light" at the end of the tunnel for becoming a Sr. DBA anywhere...