Not available, but I've asked for this as well.

Would this help?

http://www.sqlservercentral.com/scripts/96623/

You can want it all, but you can't have it all unless you can spend some money on resources. You'll have to make tradeoffs.

If your app goes to other databases...

If you grow the files, they should be at that size on restart. Are you sure you manually grew them and didn't just assume they'd stay the same because they...

The Azure test is interesting, however I'd recommend you set up a virtual machine. Lots of free players, including Virtual Box.

you can then go through the install yourself.

I assume you want a create or alter script of some sort. the problem is that you are always working with two versions to generate changes. Otherwise, how can you...

Jamie Ingram-729524 (7/8/2013)

---

Can I just whinge about the link to the updateable snapshot?

What's wrong with updating the base table and then regenerating the snapshot? This is a far better solution...

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