Try returning LogDate as a datetime2 instead of datetime. Some programs, like Excel, do not format datetime very well.

The total rows suggests you have not SET NOCOUNT ON; at the...

• This reply was modified 1 year ago by  Ken McKelvey.

As you are using a trusted connection (-E for SQLCMD) it might just be easier to exec a signed stored procedure. I cannot test anything at the moment but something...

• This reply was modified 1 year ago by  Ken McKelvey.
• This reply was modified 1 year ago by  Ken McKelvey.

Thanks. That is certainly worth thinking about.

Sorry for the late reply.

Currently we have an onsite system where images/documents are stored in the database. We are considering if these should be placed on the file system, or...

You might be able to use Convert_HtmlToXml in the following to get XML which you might then be able to process as you want.

https://sqlsharp.com/features/

I suspect it would be better...

Yes. I would have thought this is the main use of Micro...

Fair enough, the SQL generated by EF is a lot better than it used to be. It is just my experience that...

While EF has some nice advanced features, is there any reason why the bulk of the DB access cannot be done with Dapper and...

What is an AOR job?

If ESP means...

I have experience with two large systems - one with FILESTREAM blobs and the other using normal blobs.  Both ultimately got migrated out of the database into an object...

Another approach would be to sign the stored procedure and create a certificate user in MSDB with appropriate permissions. It can get a bit involved but the following may help:

If you are using four part naming try using OPENQUERY instead.

There should be no need to copy data to a temp table; just replace #t with the name of your table/view and adjust the column names accordingly.

Consumable test data:

CREATE TABLE #t
(
    ID int NOT NULL
    ,SomeDate datetime NOT NULL
    ,Flag char(1) NULL
  ...

• This reply was modified 1 year, 1 month ago by  Ken McKelvey.

ZIP files are binary files so will not save correctly as a string. Binary can be encoded as a string although the size will obviously be increased. One way to...