UPDATE msdb.dbo.sysschedules SET msdb.dbo.sysschedules.owner_sid=job.owner_sid
FROM msdb.dbo.sysjobs job (NOLOCK)
inner join msdb.dbo.sysjobschedules jobsch (NOLOCK)on job.job_id = jobsch.job_id
INNER JOIN msdb.dbo.sysschedules sch (NOLOCK)on sch.schedule_id = jobsch.schedule_id

create procedure dbo.sp_change_job_owner
@jobName varchar(500),
@ownername varchar(60)
AS

DECLARE @owner_sid varbinary(85)

Select @owner_sid= sid
FROM master.sys.syslogins(NOLOCK)
WHERE name like @ownername

UPDATE msdb.dbo.sysjobs set owner_sid = @owner_sid
where name like @jobName

UPDATE msdb.dbo.sysschedules SET msdb.dbo.sysschedules.owner_sid= @owner_sid
FROM msdb.dbo.sysjobs job
inner join msdb.dbo.sysjobschedules jobsch on job.job_id = jobsch.job_id
INNER JOIN msdb.dbo.sysschedules sch on sch.schedule_id = jobsch.schedule_id
WHERE job.name like @jobName

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/replication-stored-procedures-transact-sql?view=sql-server-2017

1. Add one or more articles through one of the following methods:

   • Add Articles to and Drop Articles from a Publication (SQL Server Management Studio)
   • Define an Article
2. After adding an article to a publication, you must create a new snapshot for the publication (and all partitions if it is a merge publication with parameterized filters). The Distribution Agent or Merge Agent then copies the schema and data for the new article to the Subscriber (it does not reinitialize the entire publication).
   • To create a new snapshot, see Create and Apply the Initial Snapshot.
   • To create a new snapshot for a merge publication with parameterized filters, see Create a Snapshot for a Merge Publication with Parameterized Filters.
3. After the snapshot is created, synchronize the subscription to copy the schema and data for the new article.
   • To synchronize a push subscription, see Synchronize a Push Subscription.

   • To synchronize a pull subscription, see Synchronize a Pull Subscription.

–unable to turn on publish for db and showing error for the distributor has not been installed correclty

 
exec sp_replicationdboption N’TEst’, N’publish’,’true’
select @@SERVERNAME

sp_addserver @server = ‘servername’ ,
@local = ‘local’
, @duplicate_ok = ‘duplicate_OK’

sp_helpserver

sp_adddistributor ‘servername’

sp_adddistributiondb N’distribution’;
sp_adddistpublisher @publisher = ‘servername’, @distribution_db = N’distribution’;

–You can run this query to get a list of remote logins that exist on the server.
— Query to check remote login
select
login.remote_name as RemoteLoginName,
svr.srvname
from sys.remote_logins login join sys.sysservers svr on login.server_id = svr.srvid

sp_dropremotelogin old_server_name
GO

https://www.microsoft.com/en-us/download/details.aspx?id=13255

bcp “select top 1 plot from Adventureworks2016.dbo.Plots” queryout “c:\tmp\image.jpg” -S localhost\AMT2016 -T

drag matrix into design pane select report data
, drag month_name into rows
, drag physical_year into columns
, drag member_cnt into data.
Preview. When happy build and deploy

matrix view in SSRS

orignial data rows view

source: https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017