You can use the DataReader DB role. Just add the RemoteLogin's user in the database to that role.

You could just return your table data from your proc as SELECT output and then the caller could catch it by using the INSERT..EXEC.. statement.

search for "Parameter Sniffing"

Jeff Moden (1/2/2009)

---

Heh... while that may be true, your patience and depth of explanation are noteworthy. I'd have killed...

I agree with Steve. There is no reasonable way that SSMS could be the cause of this (I can think of one unreasonable way, but it is extremely unlikely).

I...

Can you show us the execution plan?

Whoops hang on, I misread your question...

hmmmm,... well it depends on what you mean...

You do have to include a port-number in the CREATE ROUTE command, but as I understand it,...

I have not tried it myself, but according to Books OnLine (CREATE ROUTE article), the answer is yes.

Heh. I thought that you would like that one. 🙂

The approach that I have used for this kind of sub-sequence number generator is like this:

INSERT Into ChildTable(...)

Select @ParentID

, 1+Coalesce((Select MAX(ChildID) From ChildTable c2

Where...

Jeff: I think that the URL link at the end of your last post is messed-up.

edit: OK, you're too fast for me. Three posts back...

SQLBOT (1/2/2009)

---

RBarryYoung (1/2/2009)

---

SQLBOT (1/2/2009)

---

Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's beyond my meager skills if it is possible.

It...

Hmm, I had thought that that was not possible, Steve, but looking at it now on my server, it appears that you can do that.

I am not sure if there is any way to do that directly.

Indirectly, you could try to implement an approach using SQL Agent Jobs or using Service Broker, but that...

SQLBOT (1/2/2009)

---

Can you loop through dm_db_index_physical_stats and reindex all the databases that require reindexing without an iterative structure? It's beyond my meager skills if it is possible.

It probably wouldn't...