Did you actually read the error? It appears that your file path is incorrect. There are duplicate "\" in the string.

You are not going to be able to bring the master and msdb databases from the 2012 instances to the 2016 instances.

There are differences in the databases in the various...

I (occasionally) work with an app like that, thousands of tables,  no foreign key constraints, even better, if you add an index to a table, the...

When you find out, let me know too.

There is a potential gotcha with this syntax:

WHERE [Invoice Date Key] BETWEEN '2014-01-01' AND '2014-12-01'

The data types of the table in this example are of...

One idea:

Add every server to a group in Registered Servers in SSMS.  Then, open a query from that qroup which will open the query connected to every instance.

You...

There is a potential gotcha with this syntax:

WHERE [Invoice Date Key] BETWEEN '2014-01-01' AND '2014-12-01'

The data types of the table in this example are of "date" types....

I don't know about the last month, the jury is still out, but last night was pretty good.

We were watching the Justice League movie.  Myself, and my 10, 7, 5,...

What is the difference between this question and the one pasted here?

https://www.sqlservercentral.com/forums/topic/sum-of-column-when-values-different

SELECT 

 SUM(CASE WHEN COLUUMN1 = 1 THE COLUMN1 ELSE 0 END),

 SUM(CASE WHEN COLUUMN1 = 2 THE COLUMN1 ELSE 0 END),

And so forth

FROM YourTable

WHERE Column2 = 1

• This reply was modified 6 years, 3 months ago by Michael L John.

You're first sentence struck me.

Have you ever been the sole DBA at a company from the ground up? Me either.

Yes, almost always in my case.

are you suggesting a separate publication/subscription  for each table?? - not sure about that approach

you should be able to do this in a single publication with a couple of...

here's a thought, could it be possible to script up something  that re-initialises the subscriptions and runs the snapshot job when a DDL event occurs (e.g drop table) you...

How large, and how frequent, are these tables created?

I'm thinking that you set up transactional replication, and then automate the creation of a subscription and initialization of the subscription for...

One addition to Jeffery's post.  The SIDS only matter for SQL logins.  Windows logins use the active directory SIDs.