In  this document, it mentions a related windows task when setting up an AG of setting the HostRecordTTL . I'm guessing that that's a setting that could influence the stability...

This is me guessing, but according to this article the SQL Browser Service uses UDP on port 1434. So maybe you're not allowed to use UDP on that port?

https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access?view=sql-server-ver15

This is an old thread and the tools are shifting. Today Azure Data Studio is the better tool for this kind of work. It has an export to Excel built...

I have a table Table A  with a flag  like below. I am getting the latest record for ID  based on latest date. Something like below.

But I need to...

Copy/paste error, I'm guessing? As...

• This reply was modified 3 years, 7 months ago by kaj. Reason: Wrong person quoted

I can only join the chorus in advicing you to define table columns correctly, according to use.

If a column is to contain numbers then define it as such (int, dec,...

I can make the msdb.dbo.agent_datetime function fail by supplying an invalid date value, such as 0 (zero). If you have invalid date values in your job history, and I'm...

In my case the SQLAgent script chokes on a disabled job where the date and time values passed to the function msdb.dbo.agent_datetime(R.run_date, R.run_time) are null values.

Same here. Two Agent jobs returned and then the script...

I'm no expert on MySQL at all (never used it), but I'm a little confused about the reference to MariaDB in the error message. I know MariaDB started out from...

Okay, yes, you are of course correct. GO is not a TSQL instruction, so it cannot be used in a stored procedure.

I would try to split the code into two...

You probably have to insert a batch separator (the standard batch separator is GO) before your -- SOME LOGIC section.

tsql - SQL Server: What are batching statements (i.e. using...

This should work, I think:

UPDATE t
SET t.CarStatus = '2'
FROM #Test t
INNER JOIN (
    SELECT CarID, MIN(Id) AS Id
    FROM...

Or maybe even better, simply reverse the order of the join criteria? Might work... 🙂

SELECT a.a3ltrcode, b.CommentCode
FROM a3ltrcodeTBL a
INNER JOIN Comments b ON a.a3ltrcode =  
...

• This reply was modified 3 years, 10 months ago by kaj.

I have a table with 3 letter codes, and I have a comment table with comment codes. The comment code used is dependent on the 3 letter code. So...