Phew, another mystery averted 😛

Thanks for posting the rest of the story Clare!

Of course! I did not even think to ask if lpim was enabled. Most people do not turn that on with x64 without a reason. That must be it.

@GilaMonster, @MysteryJimbo,

I think the OP is saying memory used by sqlservr.exe per Task Manager (count on Processes Tab should include buffer pool for x64 SQL) is only 124MB but...

RBarryYoung (9/10/2012)

---

opc.three (9/10/2012)

---

...

I don't know about that. If it were denied on public in Clare's environment then she would not have seen the listing unless she explicitly added a GRANT...

RBarryYoung (9/10/2012)

---

opc.three (9/10/2012)

---

RBarryYoung (9/10/2012)

---

...

public does have VIEW ANY DATABASE by default and my test instances do not undergo any changes to those permissions. REVOKE simply clears an explicit setting on...

RBarryYoung (9/10/2012)

---

opc.three (9/10/2012)

---

I just tried it on another machine using SSMS 2005 connecting to Developer Edition 9.0.4060 and I cannot reproduce what you're seeing. Are you using...

Jeff Moden (9/10/2012)

---

the first place to start would simply be to join the new table with the existing table based on the first name, last name, and DOB and use...

I just realized you posted in a SQL 2005 forum for which Table Valued Parameters (TVPs) are not an option.

Some options for passing a table (i.e. an array) to...

In SQL an array is modeled as a Table.

Parameters to a stored procedure are more like arguments to a method in C#, however there is no concept of overloading in...

I just tried it on another machine using SSMS 2005 connecting to Developer Edition 9.0.4060 and I cannot reproduce what you're seeing. Are you using the repro...

Crazy. Which build please because I get the same behavior on my 2005 Developer Edition instance build 9.00.5000.00.

Here is my test code polished up for public consumption:

----------------------------------------------------------------------------------

-- step 1: run these commands as a sysadmin

USE [master]

GO

IF EXISTS ( SELECT *

...

MissTippsInOz (9/9/2012)

---

..actually REVOKE is enough I believe. Certainly worked when I tested because it was something I thought...

Maybe. People learn in different ways. It was stated, but may not have been completely clear to the OP or other readers what you were pointing out so I added...

I am not sure what that would do to the installer. If the installer tried to open multiple connections it would fail, and it may in fact change the mode...