You can setup one-way transactional replication.

Also I don't see how running an SSIS packages is any more secure..

To me this seems like a perfect job for the service broker ( or possible trans replication as mentioned), I agree with everyone else that I would...

the way I would do this would be to use a script task prior to the dataflow in the loop , in this script tasks use the ...

what errors do you get for the backup failure?

in regards to blocking, this should not be an issue it is an important feature of a RDMS, however if you...

create an agent job to run the stored proc every 20 seconds.

I would go for the backup/restore method outlined above over the dettach/attach as this way you can have minimal downtime.

what are the problems that you are having?

may be more useful to tell us more information before we answer your questions so we are not heading down the wrong track

re-install, or myabe look in the registry.

have a look at these answers to the same question

http://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspx

you should then do this in classic asp, SQL Server is a server application and is not meant to pass error messages to the end user.

code your asp app...

you should change your plan to remove the Shrink DB and log tasks all together, it is not good practice to regularly Shrink either.

set up t-log backups to manage...

duplicate attribute members should not be a problem, I would check the attribute relations to see if the column is being used in a relationship and would need...

are you adding it as an attribute or a key?

also in SQL sometimes scenarios that work on a scaled down query do not follow through to work in the same way in a more complex query, as...

BinaryDigit (7/11/2011)

---

I understand that no filter will be applied what I'm trying to find out is if the first part of and is true would the second part still run?

I...

deletes are still logged in simple mode, as are all the transactions.