How often do you do FULL backups?

Hopefully resolved this via PM, took a look at the OP's SSIS package and was what I looked at setup incorrectly.

Detailed to use a ForEach loop to pick up each...

What edition of SQL are you running Enterprise, Standard?

How often do you need to refresh the destination database? Does it need to be close to real time population? ...

SQL 2008 R2 source, restoring to SQL 2008 destination.

Your essentially downgrading the database which cannot be done.

If you want to restore the database on the destination it needs to be...

I would start with the following http://www.sqlservercentral.com/stairway/72494/

Its the metadata of objects like views, triggers, procedures.

You can query it, using a open ended like clause on the definition column for the table name in question

SELECT * FROM...

Yes that is correct, any referencing objects need to be manually updated with the new table name, SQL wont do it for you.

It even gives you a warning once the...

Any references to that table will break once the name is changed, so things like views, functions, procedures etc will need checking to see if they reference the table in...

What do you want to make dynamic?

But yes if you write dynamic SQL then you can make it dynamic.

A good case for ROW_NUMBER()

drop table #data

create table #data

(

contactid int,

totaldue money,

rn int,

maxrn int

)

insert into #data

select 1, 49846.693, 1, 1

union all

select 1, 43214.9511, 2, 2

union all

select 2, 43962.7901, 1, 1

union all

select...

Ask your mail admin to perform...

Outlook is for SQL Mail, not database mail, the two are completly different.

DBMail uses SMTP, you need to ensure that the SMTP server you have specified on the profile and...

What about setting up replication for the table(s) in question?

You will need to ensure that you have unblocked the database mail exe from any anti virus progress which block mass mail worms, and if using Microsoft Exchange as your...

mrichardson 57577 (1/10/2013)

---

I have tried just " on its own, and that didn't work - import fails.

example of the content (when the database is set to limit data entries to...