I understand.  Although I have trouble doing anything quietly these days.

If the link fails for a short time (you configure how long), replication will essentially wait and send the transactions when the link is back up.  You can configure replication...

Microsoft changed a bunch of their licensing policies with SQL 2005 (I'm sure you have a shocked look on your face right now).  The reason your product key was disabled...

I have found that SQL 2005 manages memory dynamically quite well.  I have found minimal performance gains by setting the minimum and maximum memory for a server.  Now, I have...

It is easy to branch on whether a record exists or not.  Use aa SQL command to return a field from the record and then set your data flow to...

Do you really care to fix these issues?  I assume you are either setting up a failover solution or this is simply a test restore.  If the final piece of...

You can either look for the red X, or double-click on the error in the errors / warnings list.

I am sorry to say that if you have a lot of...

We use the multi-select all the time and it seems to work fine.  I am guessing you are trying to use it with a store procedure as the source of...

The error is indicating you have at least one connection to the database that is still active and doing something.  You cannot shrink the log file if it is currently...

I'll start by saying you should go get a book about data warehousing.  There is no way I can explain this in a few short posts.

A very common data warehouse...

Replication had a lot of changes from 2000 to 2005.  We have, however, been replicating to and from 2000 and 2005 databases for nearly a year without any issues relating...

If your 2005 server is a new server or a new instance and you can leave the old one running, you can actually replicate (assuming all of your tables can...

You can also set connection information at runtime through expressions.  If you need something really dynamic - say passing in the username and password through a user interface - package...

Synonyms give you an interesting option for this one.  You could create database A and B with actual data and a third database C with synonyms to all of the...

BTW, your update to the sysdatabases table did not work because it is not a table in SQL 2005 anymore.

It is a view based on the sys.databases table that is...