Are the variables using the script task setup to be "ReadWriteVariables" (yeah - kinda obvious but I gotta ask).

Have a read of https://msdn.microsoft.com/en-us/library/ms147834(v=sql.100).aspx - it has the info you need for creating publications from database backups

There is no need to snapshots after the first one. Chances are, whoever setup that 3 day schedule did not understand the architecture of merge replication.

Briceston (1/1/2016)

---

Happy New Years fellas!

So I have a SSIS package that creates a report with the destination of the excel file being my local drive. I introduced a file system...

You need to include the article in the subscription - the code you include adds the article to the publication but it does not add subscribers.

Depending on what...

If you create a placeholder in the textbox, you can use some HTML codes to format the text. Have a look at https://msdn.microsoft.com/en-us/library/dd207048(v=sql.120).aspx

Check the definition of the Distibution agent for each of the subscribers - perhaps one is continuous and the other is based on a schedule

you will need to SUM the relevant column - this then exposes the result as a measure. Select the column and the click on the sigma sign in the...

First - once you have a subscriber setup with its initial snapshot, the snapshot agent is not required to be run.

For merge replication, each database (publisher and subscribers)...

Mmm, that was nasty. I oh so want to see someone try to create anything remotely like that on my watch.

Create a new instance of SSRS (same version as the failed instance, or a later version). Once the new instance is up and running, restore the databases (ReportServer and...

How can the "correct Answer" be 4 when all rows are returned. By my reckoning there are 5 rows !

Integration Services would be my first choice - either using "Import Data..." (available in Management Studio when connected to the on-premises database) or using SQL Server Data Tools

Have a look at view INFORMATION.TABLES and INFORMATION_SCHEMA.COLUMNS - these should be able to give you what you need.

SSRS Standalone and SSRS SharePoint Integrated Modes peacefully co-exist on the same server - there are no issues in doing this that I have encountered. I have a server...