You could also avoid mapping the login to a db user completely, so that it can't access the database at all.

Public role doesn't have table access, don't worry about that.

db_owner is referred to a single database, it's not a server role.

You just have to create the user as db_owner of the target database and leave it as "public" on...

Paul White NZ (10/18/2010)

---

Kit G (10/18/2010)

---

Heh. I dislike the whole "Green" thing. And that stems from my total disgust at the whole Global Warming/Climate Change "science" that isn't...

GSquared (10/18/2010)

---

If it's a large amount of data from Server B, then you might want to insert into a table variable, then from that insert into a temp table that...

I would import the minimum possible amount of data (only required fields) from the remote server into a temp table, index it properly, and then update the local table.

Such a...

CREATE PROCEDURE testMaxValues

AS

BEGIN

SELECT CASE

WHEN (SELECT MAX(MonthId) FROM TableA) > (SELECT MAX(MonthId) FROM...

Well, I was wrong.

When I see things like "plz" and "How can i write the Sp PLZ let me know" I...

If I got things wrong I apologise.

Anyway it doesn't look like you read the article I recommended.

To get an answer you should state your question with the following elements:

1) Table...

Plz, do my homework!

Plz, do my homework (reloaded)!

http://www.sqlservercentral.com/Forums/FindPost1006152.aspx

Looks like homework.

Am I wrong?

The point I'm trying to make is that your question doesn't contain enough information to get a sensible answer.

Read the article and add the requested info to your question.

You're not going to get useful answers for this problem, unless you take the time to describe it properly.

See the article linked in my signature and find out how to...

Oh, sorry!! :blush:

No offense meant!...

WITH zones AS (

SELECT dnsname, alias

FROM dnszone AS A

...