One of the simplest ways of doing this is to do a backup and a restore.

The T-SQL is pretty clear in books-online.

Since you are talking about possible schema changes and data differences, I would suggest you look into a database differencing tool rather than starting yourself on some quest to build...

You can use a lookup for this if you want. Re-check your data types on your data flow and on your table. SSIS is very sensitive about data...

You cannot within a trigger, but you are describing a scenario that Service Broker is pretty well designed to handle. You may want to read up on it.

Transactional Replication works fine over a WAN.

Keep in mind that transactional replication, by default, sends one record at a time, not one transaction. It uses a transaction on the...

Yup - you are right.

My bad.

Interesting that you think that is simpler. It makes a circular reference - meaning you cannot insert the Firm record without already having a Firm/Ticker record to be the...

I guess I assume your WAN is either using some kind of VPN tunnel or it is a frame relay or something that is already secure. That would be...

Sorry to hear you are still using ODBC DSN's.

Other than making sure you have a connection that is stable and you have enough bandwidth, a WAN connection is not going...

Yes, you are right - it would need to be a TinyInt to sum it.

As far as the "do I put the logic here or in the application?" question, there...

I don't have report manager right in front of me at the moment, but after you execute a report, there is another control - I think it is next to...

I don't know if you have conveyed your question correctly. A Job Agent job does not have to impact a database (other than MSDB) at all. A job...

Do you mean search within a report result in Report Manager? There is a control on the screen for this.

See if anyone else posts.

I always thought those options were a bit of a workaround, so there may be something easier.

You could do this with a check constraint. That is prbably what I would lean toward. I think you could probably get better performance out of a well-designed...