Scott

Also, if they're domain admins, they'll be able to see the SQL error logs (errorlog, errorlog.1 etc) as text files, without using Enterprise Manager.

John

KR

Do you have any filters defined in your publication that may cause certain rows not to be copied?  I suppose this is unlikely to be the reason if one subscriber...

OK, I see from your thread on SQL-Server-Performance that your problem is that only the first row of the result set is displayed in your app.  If you say what...

Carol

Check out this recent thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=263625

It seems to suggest that you're right.

John

... 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...