I have to say that I totally disagree with that.  Stop treating Developers as if they shouldn't know even the basics of SQL.  You're just making the problem worse...

A ping will return the server name/IP. It knows nothing of an instance name.

If your server is named "Server1.yourdomain.com" and the instance is "Instance1", you would be able to connect...

This first update statement in your code:

                UPDATE m2mdata01..inmast_ext
   ...

OK, I love to learn new things. Thought I posted code yesterday but possibly

declare @partno char(35)
declare @rev char(3)
declare @id numeric(15)
declare @id2 numeric(15)
declare @std numeric(1)
declare @prc numeric(1)
--Get...

Can you show us your...

First I can't stress how angry I am with Microsoft for removing debugging from SSMS. Second, I am using Visual Studio to debug now. When I build a cursor,...

Three part naming convention is the manner to call a cross database query or procedure.

From database1:

EXEC database2.schema.procedurename

Note, the permissions need to be set up properly in each database.

As for how...

To clarify, there is a column in a table in a database.  When it's value is 100, you then need to insert all the rows from that table into a...

It sounds like your vendor needs to do a little work to make this easier for you.

Here's my questions. Once you get these logs restored, and DB up to date,...

First question.  Why are you using SQL 2012?  End of life is July 12, 2022.  I recommend upgrading to a new version.

This article describes the various ports and protocols that...

You can set up replication between an on-prem SQL server and an AWS SQL server.  You need to google setting up replication without a domain.  I did it with SQL 2008...

This is nearly identical to the example provided by Microsoft.

I question testing the transaction state in the catch block.  If there is an error thrown, regardless of the state of...

Failover clustering is out, unless you can share your storage across datacenters.  It uses shared storage.

Unless I misunderstand what you are saying,  you do not need VRRP.  Availability groups contain...

Can you do us a favor?  If you are going to expect us to write your code for you, can you at least follow the guidelines that make it far...

Hello Michael,

Thanks for your reply, are you referring to the SQL Server Agent Job?

If so this seems to contain none of the readable details of the job such as...