Are you bothered about the alerts during the weekend as well as the weekdays?

If so you will need to set the alert to 62 hours for a backup threshold if...

You dont need an execute SQL task, just a data flow task.

Create connection managers for ServerA,B,C,D,E and then a connection manager for the server where the big table is going...

I would first direct you to these links

Backup

Restore

If you have any issues after that please detail what the issues are.

If your talking about a parallel data warehouse, I would of...

The only way I would of thought to do that, would be to have a subscription which runs the report and exports to excel and saves it on a file...

The data is inserted via SSIS, we receive around 10 files which are loaded into holding tables and a vary large set of manipulation is run on the data to...

X amount of data flow tasks selecting what is needed from the same table in each server, then import that into 1 big central table.

They in the report query the...

Well we go into the whole how much do you have to spend on the project.

As soon as you start using your DR servers for user queries (in this case...

Which answer?

I have just run the script in the first with @table1 and @table2 and get values for A and B back.

Another way but using merge

create table table1 (date date, product char(1), qty int)

insert into table1 values

('2012-10-10','A',10),

('2012-10-10','A',5),

('2012-10-11','A',20),

('2012-10-10','B',15),

('2012-10-11','B',10)

create table table2 (product char(1), qty int)

insert into table2 values ('A',0),('B',0),('C',9999999)

GO

merge into

table2 as target

using

(

select

product,

sum(qty) as...

Traceflag 3604 sends the outputs of certain DBCC commands to the SSMS window.

E.g. If you run DBCC PAGE without first enabling traceflag 3604 you dont see the results, so it...

This does the trick.

declare @table1 table (date date, product char(1), qty int)

insert into @table1 values

('2012-10-10','A',10),

('2012-10-10','A',5),

('2012-10-11','A',20),

('2012-10-10','B',15),

('2012-10-11','B',10)

declare @table2 table (product char(1), qty int)

insert into @table2 values

('A',0),

('B',0)

update

@table2

set

qty = dev.qty

from

(

select

Product,

SUM(qty) as qty

from

@table1

group by

product

)...

The clue is in the spatial function STGeomFromText requires a text imput.

As the error says your passing in floats and trying to build a string, change them in the declaration to varchar or convert in the query.

Doh, forgot the +, should of been an easy one to spot

DECLARE @Latitude float = 8.4827

DECLARE @Longitude float = 76.9192

DECLARE @ID int = 1

UPDATE [MarvelTour_DEV].[dbo].[LocationCopy]

SET

LocationGeography = geography::STGeomFromText('POINT('+@Longitude+'...

Query msdb.dbo.backupset, inside that table are a number of columns related to LSN's, you can then match the LSN numbers into the order that they would be required for restoring.