I'm intrigued by the use of the scalar UDF in a check constraint.

However, I'm not convinced that the check constraint will be 100% accurately enforced - due to the effects...

Figured it out. When generating the subscription directly from management studio, it automatically starts the snapshot agent. However, the script that management studio generates for the subscription does...

Right now the publisher and the subscriber are on the same machine.

Replication

+ Local Publications

+ [PublisherDatabase]: PublicationName

...

Publication works regardless of whether I use the GUI or the script generated via the gui to create the publication.

However, Subscription *only* works when created with the GUI. Subscription...

I tried completely disabling replication, which in process drops the distribution database, and resetting everything up. I am still getting the same problematic behavior.

No it doesn't. syssubscriptions is completely empty.

Thanks for all your help.

To summarize, there were 4 main suggestions:

1. Put the tables I don't care about in a separate database

2. Before the nightly load, set the db to...

Jeffrey Williams (5/26/2009)

---

How are you referencing those tables in your code? There might be a way to move those tables without re-coding. You could try creating a synonym...

GilaMonster (5/26/2009)

---

What you could try is to put the tables that you don't care about into a different database and set it to simple recovery. Doesn't stop logging, but tran...

Ok, I found how to fix my problem, though I'm still not entirely sure why it was a problem in the first place. Under the TCP/IP protocol settings, I...

Hi guys, thanks for the responses.

SSC-Enthusiastic: My understanding is that telnet only works for TCP connections, not UDP connections. However, netstat does show that 1434 is bound on the...

I'm wondering if something is messed up with the master database. We found the following in our sql logs during the time that the failure was happening.

In particular, I...

My previous post was incorrect.

I double checked, and access to all databases both for internal apps using Windows Authentication, and for external apps using SQL Authentication failed.

All SQLServices did start...

Also, we do have one application that is inside the domain (not externally accesible) that uses windows authentication, and it does not appear to be affected.

It appears that only applications...