How does the eDirectory process work? Something there must be reading data from SQL Server. Once you understand how the process works (maybe use Trace), you can move forward.

duplicating this...

First, if this is interview/homework, please identify it.

Second, you should do some research yourself. There is a lot of documentation.

Third, semantically, I'm not sure what you mean. SQL Server has...

Jim has given you good advice.

Note that when you run something, it isn't your account that runs it. It is the service account for SQL Server, not the user connected....

Note that in addition to sean's reference, there isn't just "replication" in SQL Server. There are different types, and the complexity, monitoring, and administration is different for them. You should...

Notifications working for people? Seem like the queue might be stuck.

Not sure if this is more efficient and you'd have to test, but you could join with an OR and then use a CASE statement.

Select

case

...

No idea. I'll have to ask.

You are right (as usual), Gail. I thought it would start in read-only mode, but sure enough I get a failure.

The problem is probably rights. Your system cannot open c:\xxx.mdf...

There should be information in the SQL Server error log about it starting. Look for that. tempdb being broken doesn't prevent the instance from starting.

jasona.work (7/5/2013)

---

Hmm, can we amend that to be:

We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain unalienable...

Hope everyone had a good Fourth. My day?

We leave late for the mountains (1), hit traffic (2), Tia's hungry, but everywhere in Idaho Springs is packed and busy (3). Hit...

I hate doing this in individual emails, since I think it's a poor design practice. Over time, or when things are busy, people get tons of emails that aren't necessary....

Lowell does it the way I'd do it if the data is static.

If it's not completely static, or may change often, then you could use another table.

create table status

( code...

What's in the error log?

swwg69 (7/4/2013)

---

As a father with daughters, I worry about the indiscriminate abuse by single FBI agents. Let me cross reference birth control pills with condom purchases and bar patronage....