Something like this http://www.sqlservercentral.com/scripts/String/89388/

Do they have to go into the same DB?

Could you not use union and 3 part naming convention

eg

select ... from ProdDB.ProdSchema.ProdTable

union

select ... from ArchiveDB.ArchiveSchema.ArchiveTable

Other methods would be to SSIS the...

Take a look at Perry's stairway for always on, it goes from the OS cluster setup upwards and will detail steps needed to create the WSFC and enable AlwaysOn

As you can imagine there is no released official MOC yet and with the product still months away from release with many changes potentially still going on before even an...

First result in Google brought this

https://technet.microsoft.com/en-gb/library/cc262485.aspx#section4

So as long as your above the May 2014 CU then your ok.

Sublime

tableau

Bobblehead (hurry up 4pm UK time, need to get home to play Fallout 4)

OK, here's my "whole server" permissions script

IF OBJECT_ID('[tempdb].[dbo].[#TMP]') IS NOT NULL

DROP TABLE [dbo].[#TMP]

CREATE TABLE [dbo].[#TMP] (

[DBName] SYSNAME,

[Type] VARCHAR(20),

[Object/Role] SYSNAME,

[Login] SYSNAME,

[Access] VARCHAR(20),

[Permission_Name] VARCHAR(20)

)

USE MASTER

declare

@isql nvarchar(max)

...

What if the node needs a reboot during the maintenance? Do you want a loss of service?

Generally my stance on maintenance at the OS layer for SQL Clusters is...

Only thing I could find is for Toad for Oracle https://www.toadworld.com/products/toad-for-oracle/b/weblog/archive/2011/02/01/configuring-toad-174-team-coding-to-use-microsoft-team-foundation-server-2010, seems it can be done, might be one to speak to Dell about to ensure it can be done...

Yes, again if you don't want that to happen, hack the script to remove it.

Alternatively as your hacking the script, write your own script to backup the databases how you...

You shouldn't have to change any permissions in the ReportServer database. That database is purely for the SSRS service, when you run through the SSRS config setup it sets...

Reported

What kind of subscription delivery are you dealing with? Email / File Share? If file share you need to set the unattended execution account on the SSRS config...