It's been quite some time since I've actually used VB, datagrids in virtualmode isn't something I've used so i wouldn't like to hazard a guess.

I did wonder, instead,...

Can I presume that the datagrid is therefore interactive and acts as a 2 far interface (both for returning data and inserting)? If so, I'm not sure you can get...

There's not even an error message there. Did you run the file As Administrator?

I agree with the others, you don't want to store your data in different measurements, you should store them in 1 and convert at the front end. How do you...

Try this:
SELECT t.c.value('(message/text())[1]', 'nvarchar(100)') AS [message] ,
       t.c.value('(to/text())[1]', 'nvarchar(100)') AS [to],
       b.d.value('(text())[1]', 'nvarchar(100)') AS [from]
FROM @x.nodes('/revieves/recievemessages') AS t(c)
    ...

Apart from that it's spelt SINGLE (not SINLGE), you're attempting to pass a variable as part of the SQL, which you can't do. Much the same way couldn't do

Or you know, you could just turn BBC One on ;)... Spam reported.

I can see MSSQL12.MSSQLSERVER and MSSQL12.SQL2 in your images.

Duplicate of post https://www.sqlservercentral.com/Forums/1854197/export-to-xml-file-with-separate-rows. Please keep to one topic per question.

I think i understand what you're saying.

I've written this for my own log table for our website (so you'll need to amend for your own table names)  which...

I'm not quite sure on the question, sorry, however, what is the point of this statement: datetimestamp >= DATEADD(day,-1, datetimestamp). datetimestamp is always going to be greater...

Chris is right, moving the jobs to an Agent on a different server isn't going to achieve much, as the jobs are still going to interact with the server that...