... or, even better:

SELECT COALESCE(address2, address1)

FROM tablename

Haven't tested this, but try:

SELECT 'Address' =

  CASE WHEN address2 IS NULL

    THEN address1

    ELSE address2

  END

FROM tablename

John

Charles

Add the /3GB to the boot.ini file on both cluster nodes.  This will allow SQL Server (and any other applications) to grab 3GB while reserving only 1GB for the OS. ...

Ryan

I suppose it depends how much of your read/write is write.  Transaction logs are written to sequentially so if you have a fair amount of write activity then you should...

John

You can have two default instances if you have two virtual servers on your cluster.  Or at least I imagine you can...

John

Thanks, folks.  I had the extra rules put on the firewall and now it works as it should.

John

Hilary

Thanks. On the subscriber, the %computername% and @@servername information were identical. On the publisher they were identical except that @@servername had \instancename on the end.

I created the aliases...

Yes, you can replicate between default instances.  We have set up transactional replication with no problems on default instances.

John

Yes!  It does say that.  But why is that table being truncated successfully in one subscription but not in the other?

I do want the data deleted from the table, but I...

I am using transactional replication, but obviously this starts off with teh snapshot being applied.  Yes, I created the table on the subscriber using the exact same DDL as on...

Hilary

Thanks, but my publication uses concurrent snapshot processing, and when I try to subscribe to just one article, I get a message saying I have to specify all articles.  Is...

Hilary - thanks.  I think sp_addscriptexec would do it.  I've actually now created the SPs I want in the subscriber database and configured them not to be overwritten during the...

Not if you protect the DTS package with a password.

You need to ensure that the correct trust relationship is set up between the two domains.  After that, grant the account that starts SQL Server the necessary permissions on the...

Assuming you are using SQL Server 2000 (SQL 7.0 doesn't support multiple collations on the same server), use rebuildm to rebuild the master database, specifying the new default collation.  Beware,...