Re: queries. You can jump to your desktop if available and run queries, or run them locally. What you do may depend on networking. Ideally, I'd run them from my...

Make sure if there are no rows that you have some value (not null) in the variables. You could do something like

SET @tableHTML = COALESCE(@tableHTML1, ' ')...

Hmmm, I would lean towards some rights here in some way. Maybe try moving the cert backup to a local drive. Ensure you're sa/dbo here as well. Try a different...

There is no guarantee of ordering when selecting from a table without an ORDER BY

You are welcome and good luck.

Take notes, and we'd love to see an article if you get this working. Would help others.

Top are GF cookies, and they break apart quickly.

Were you able to create this certificate in master or on any instance? I've had some issues with certificates in SQL Server as it doesn't seem to support every format...

I'm with Jeff. sp_lock or sys.dm_tran_locks should tell you if anyone has a lock on the table, meaning they're using it.

https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-tran-locks-transact-sql?view=sql-server-ver15

Frederico and Mike have things to think about. This is almost always IO driven, so the more IO you can throw at it, the better. Even if you restore the...

Maybe you (sram24_mca) could explain more about why you asked the question or what you are thinking here.

Is this the type of thing you're looking for?

https://discuss.elastic.co/t/continuous-data-from-sql-server-into-logstash/159929

LOL, I'm fairly clean when I cook, washing pots and dishes while I can. I like to have things relatively clean and neat when I'm done.

Now my FIL, I'm not...

Shifting gears a bit, today's editorial on Routine has a broken discussion link.  The editorial is all about the changes people are having to make because of recent world...

Not sure if you like cooking, but it's something that's...

Good catch. Added the quotes to the SELECT.

That example doesn't need quotes for the connect.  However, in selecting a value, it needs to be valid. In this case, the original...