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

This is moot because the OP got a solution, but since we're discussing...

Taking a FULL backup resets 'the differential base' unless taken with COPY_ONLY. NO_TRUNCATE may or may not reset...

na1774 (9/8/2012)

---

Hi All,

The issue is I have to give permisions to a user just to create objects in only one schema and deny creations in other schemas.

I am a...