I'm confused what you mean by the subscriber is not accessible? Replication runs continuously, so is the subscriber never accessible? Or do you have scheduled subscription pull/push?

I haven't seen...

Irony indeed.

I don't think it would be that hard to enable some features in Enterprise edition. I would love to be able to buy a few of the high end...

There's no way to do this automatically. You would have to write code, either with triggers that handle things, or with some other management from your application. Even with triggers,...

Ah, good catch, jcncarter.

In 2000, only 2GB is supported for Std. This was a 2005 forum, so I wasn't thinking. Won't matter in that case.

I was searching for as reference, but can't find one. I believe Jason is correct, SQL Server, 32 bit, needs AWE to access more than 2GB of RAM.

Both scary and reassuring. You can make a mistake and keep your job, but why wouldn't this be a terminating offense?

Identity could be tough. What about someone that purchases, say beer, and wants to remove that? Not sure that's a valid removal item. Some places are also required to have...

Check local community colleges. Many of the...

There are a variety of sessions. I've seen basic as well as advanced ones at various events. I ran a very high level, non-technical session last weekend at a Denver...

I'd second Mike's suggestion for a trace. That will help narrow down from where it's running.

I'm not sure I like email as a PK either. I might use it as a unique column, and display it, but since it is something that can easily change,...

Well this was interesting. Had someone ask for their account to be closed here since the questions haven't been good the last month and the quality of the discussions has...

The Bears are kind of a football team. With Cutlet at QB, they're not a great imitation of one :w00t:

jinlye (3/2/2010)

---

What surprises me is that this was the number one 'featured article' in this week's mailing from sqlservercentral.com. This must either be because:

A) The 'featured articles' are just...

The service account is the account that runs SQL Server. You can see this in EM, in the server properties. That is the account that likely is running your...