I think you trimmed your field by accident in your import.

You are saying:

If FieldA has 'Hot' and FieldB has 'Water', FieldA+FieldB is 'HotWater' (bad)

If FieldA has 'Hot Wa' and FieldB...

Defaults in SQL Server do not convert NULL into a default value, they convert empty parameters into the default value. This is the same as setting a default for...

I cannot remember if the conditional works though.

If it cares that it is just a select statement, you may have to write it more like:

SELECT MyEmail, MyName

FROM MyUserList

WHERE MyReport =...

You can use the data-driven subscriptions for this. If your email list for the subscription does not return any results, no reports will be sent.

So, you can create a...

Returning only the records you need to display the page will almost always be the better choice.

The ASP.Net controls for Visual Studio 2005 and SQL 2005 have specific support for...

In my opinion, "Transactional Replication" was a poor name to use in the database world. When you think of transaction, a DBA will immediately think of BEGIN TRAN and...

"Unsafe" means a lot of things, but the important thing to remember is that the CLR is going to try to run this in-process. So, if the .dll you...

The cube migration is a bit ugly. Since the structural differences in how you "should" build a cube in AS2005 is so different, even when the migration wizard works,...

I will agree with Matt except for the possibility that you may be able to reduce the size of your backups by moving relatively static data into file groups that...

We use replication heavily between 2000 and 2005 servers.

We have a central master data server (SQL 2000 sp4) that is the publisher and distributor. There is transactional replication running...

You have to be careful, but this can be implemented pretty safely. Using the CLR to call a web service works fine.

The most common things to work out are...

There is a system function to get it for the current connection:

select host_name()

Keep in mind that this value is completely configurable in your connection string. So, if the programmer...

Typically, it is best to let replication create and use a snapshot to initialize a subscriber. This will ensure you get the correctly selected articles in the subscriber database...

If you think moving to Service Broker will save you from re-writing, you are pretty likely to end up surprised.

Without any details, I cannot be of too much help, but...

He is correct - use SQLCmd (it is the new version - I forgot I was in the 2005 forum).

Books Online has this well documented.