A thought (it happens :-)):

Have you tried looking at and comparing the routing tables on both servers to see if packages take the same route from both sides? Done a...

Have you tried string.Split(new string[] { "|--|" }) ?

The split function is actually expecting an array of strings.

https://docs.microsoft.com/en-us/dotnet/api/system.string.split?view=netframework-4.5

I retract my comment about HostRecordTTL being able to influence the stability of a connection. I saw TTL and somehow immediately assumed it was related to network TTL. Which...

• This reply was modified 4 years ago by kaj. Reason: Typo

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 4 years 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...