Hello Mike,

thank you very much for your quick response.

If i will upgrade to SP2 with web edition will it work? Or its license issue?

Hi,
It's a part of job (in server "a") and i want that the last step will start another job at server "b".

Hi,

I dont need the output.

The remote procedure just update a table in the remote instance.

How can i just execute the remote procedure without linked server?

See below the solution i found 

EXEC [CopyFilesFromSourceToDest] @sourcepath = ' \\ServerSource\u' , @destpath = 'Z:\output\' , @Execute = 1

Create procedure [dbo].[CopyFilesFromSourceToDest] 
@sourcepath...

HI Eirikur Eiriksson,
Thank you for your quick response 🙂.
Can you please help me with this rule what should i do? 
see below a fake name and IP of...

Hi,

Thank you for your quick response.

My question is:

Where can i found an installation of sql server 2016 with Standard Edition?

HI All,
I figured it out.
This db has always-on.
The Full backup job happened on the Secondary server.
The Log backup happened on the primary server.
I found this...

Hi John,
I have added an output file please review the text below and let me konw if it's help.

"
Date and time: 2018-05-15 13:29:14
Server: *************
Version:...

Oops ??

Hello Thom,
thank you very much for your quick reply.
For some reason the SQLNCLI didn't work for me.
But i found this script and its work well for me:

Hi anthony.green and Thom,
Thanks for your quick reply!!! 
i didn't...

Hi Thom,
My business use "vantive"  which is very old ERP software (also EOL before few years).
3 years ago they decided to move to Siebel (another erp software) with...

Hi NorthernSoul,
Thank you for the answer!!!

Hi John Mitchell-245523,
An alias DNS is not an option - due to very bad experience.

Hi NorthernSoul,
Thanks for your quick reply.
I have a monitoring...

Hi All,
I found a solution!!!

i were looked for a script that will Dynamically create table with full structure.
I have 2 tables "workout" (with the most recent data)...