That's what I'm getting at: there won't be a separate warehouse anymore. Although historical reporting will not be done against the live database.

And yes, the application will be managing the...

Our product *is* the information in our database: if some of that content does in fact change 10 times in 10 minutes -- an unlikely scenario, but theoretically possible --,...

Where is gets complicated: our DB is effectively both OLTP and DSS/warehouse. For many years, we've been able to segregate the roles on separate servers, by refreshing the DSS server...

Hmmm. I see I've used the wrong term: I guess that should be "Temporal Database".

Although to be honest, I can't really see how they differ... tables have valid-from and valid-to...

Hi Shawn,

Thanks for the response.

1) Yep, as long as I know the password, life is fairly simple. But I don't. Which brings me to...

2) Execute As or SetUser would...

I like that, a little easier on the eyes.

Something like this?

http://mspowershell.blogspot.ca/2013/01/executing-tasks-in-parallel-in.html

Using my credentials (I'm a member of local admin on domain_1 SQL servers, and member of sysadmin on the SQL Servers. I'm an average user on domain_2.)

Msg 15404, Level 16,...

Hmmm....I wonder if we changed the SQL Server account to one from the other domain?

D'oh! Too easy.

Thanks Gazareth!

This should find you the rows in the result set that have the same jobno:

;with temp as (SELECT r.jobno

, r.proref

, p.proadd1

, p.propstcde

, pr.decode

, re.code

, wo.wfeedname

, m.mnodename

, wn.payval

, s.statedate

FROM repository r

INNER...

The text file is relative to the server, not your machine. So C:\Output.txt will be on the server's C:, not yours.

I have found that the copy database feature generally works...

Only a problem insofar as you have to actually know that the info is in HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\BackupDirectory, as opposed to simply asking for the server object for it's default backup folder.

Here's the basic script I use to backup all DBs in each SQL Server instance on a machine, except tempdb.

This is saved as a Powershell.ps1 script, and run via...

When I need to create a new instance of our application's DB on several servers, nothing beats PoSh.

I have a script which:

restores to a new db from the current base...