Thank you Gail for clearing it up.

Yikes! :w00t:

I...

I'm worried that the new LINQ technology shipping with SQL 2008 will open the door for more inline SQL code. I think it is a step in the wrong direction...

SERVER1/AppDb log ships to SERVER2/AppDb every 30 minutes in standby/read-only mode. Once, ~12:15AM daily*, I run a job that does a backup/restore of SERVER2/AppDb to SERVER/ReportingDb, which would then...

gravyface (3/24/2008)

---

Thanks for the responses, guys.

AFAIK, mirroring requires SQL Enterprise Edition, whereas Log Shipping does not. Can anyone clarify this? I think they'd rather not have...

Great link.

I would have preferred more info in it as well, but, all in all, I'm glad I got notified on it.

One question: where can I find the discovery.xml...

Jani Lane (3/18/2008)

---

Good day!

Don't know much about security, but I've created my web service function to return a dataset from SQL Server 2000. When I invoked the function it is...

Thank you!

This problem rears its ugly head in...

Matt Miller (3/24/2008)

---

There's also the data layer vs data ACCESS layer vs Business Layer argument. Embedding SQL calls just screws up the separation in my mind. It's not...

It is indeed as you say.

When running the same SELECT linked-server query while RDP'd directly on the source server (the server instance to which the linked server is added) it...

Connections are made using the login's current security context.

So in the following query, the login running the query is the same account in whose context the connection is attempted:

SELECT *...

For the reasons Michael so well explained I would caution against using the warm standby for reporting. If you do decide to do so, be prepared (and prepare your users)...

I'm having the exact same issue when using a linked server on a SQL Server 2005 instance (target is a SQL 2000 instance).

The exact error is:

OLE DB provider "SQLNCLI" for...

Great features but they come at a...

timothyawiseman (3/21/2008)

---

Thanks for your help. And I was looking for help in an argument I am in, Grant. If I was right (and the consensus here seems to...