I used to like SQL Diagnostic Manager by Idera for monitoring.  It kept more history than the basic logging would give.  Perhaps you can check into what your monitoring software...

That would work if you can zero in on some suspected places. Also, do you have good third party monitoring software?

Do you know for a fact which stored procedure the batch file is calling?  If so, you could add some logging to that procedure and then rigorously test the procedure. ...

IS this server a SQL Express instance?  Is it still working after removing the NT Service/MSSQL$SQLEXPRESS login from it?

• This reply was modified 1 year, 11 months ago by  Jeff Fant.

Yep.  Get a Blocked Process report and feed your findings back to us.  We're willing to help you out.  It can be a lot of things.

Hello bvjkishore,

This is a script from Microsoft that I have used many times to copy SQL Server logins (with their passwords) from one instance to another.  When you run the...

Did some searching around based on my knowledge of SQL Server and MySQL.  Found the following post in a thread.  It is taken from a Microsoft article for the MySQL...

I think that this will only work if the windows user you are using for the linked server is the same user as in your app and that user would...

Not surprised at a bit of weirdness since it sounds like the cluster is not all at the same release level.

Very interesting.  Good to know.  Guessing this SQL 2019 box was an upgrade from an earlier version...?

Need a little more info to get a clear picture. Does the query succeed perhaps when you are running the query from within server A but not succeed when you...

• This reply was modified 2 years, 1 month ago by  Jeff Fant.

There is a limitation here I think you are running into. You cannot have code that hops from outside one server and then hops to another via linked server. Your...

Looks like you have Microsoft SQL Server installed and running.  You sure you need Microsoft SQL Server?  Seems like, from your initial message, that you are attempting to use MYSQL...

Hi Di,

MySQL is a different animal than Microsoft SQL Server.  If you are running SQL Workbench, it is for connecting to a MySQL instance.

Here is where you can get MySQL...

If the production version of the app is running on SQL 2016, that's a good sign!  The dev system can prob go to SQL 2019 without too much trouble. Depends...