Failover Partner = in the connection string is only used with Database mirroring so it wont be useful for replication

are you testing this against a database with only one partition?

I suspect the SUM is to account for databases with multiple partitions

you could do this via a trigger or modify the stored proc that is used to insert data to table C to update table B as well.

Also, what is...

there is nothing sad about finding SQL server interesting --- well at least i hope not!

seany1977 (1/26/2011)

---

Ok I am a bit annoyed now. I studyed for 2 months solid before my last exam. I worked 8 hours, sometimes 10 hours in work and then spent...

I am not sure about those sites as i have never used them, but brain-dumps would be considered anywhere that republishes the exams usually from people taking them and...

Congtratulations on passing, but do you realise that using brain-dumps is against the terms and conditions of taking the exam and they could revoke it.

Have a look at the agent history and it will have an error message in there,

does the account that the sql agent run under have access to the file server and file?

it looks like you have a column with the datatype DATE in SQL 2008, this is not in SQL 2005 so you will need to change the dataype of...

I thought that going from Enterprise to Dev would...

you could create a new database on the 2008 DE and then use SSIS to transfer all the objects across.

are you trying to open a report with the parameters in the URL?

as it seems you are trying to set a value for EMPID when this does...

I wouldn't do this straight away without test that all the application code is compatible with level 100 first.

have a look at this link for instructions on getting file.exists to work in SSIS

http://dichotic.wordpress.com/2006/11/01/ssis-test-for-data-files-existence/

to work with a loop i would just map the FileExists variable from the script...