Hello,

I have simplified the stored procs as follows.

Note that the uspMain has an insert into query

create procedure uspMain

as

insert into tblData

exec uspSomeProc

...

create table #tblResult(CustID int null)

insert into #tblResult(CustID) values(360)

select * from...

Initially, I get the nested error...

So then I tried to see if I can over come the error by running dynamic sql to execute the sp and insert into a...

The stored proc has in it a few queries with insert into...

So if I run what you suggested, I get the error:

INSERT EXEC statement cannot be nested

Yes, I can see that in the message but I have checked several times and the temp table has the exact column counts and names as the result of the...

Thanks

Thanks

yes, all servers regardless of sql instances.

we do have sql monitor, but that...

Lowell (11/27/2012)

---

i believe if a login belongs to the sysadmin group, and you create a user for the login in any database, the db)owner checkbox gets inherited as readonly ;...

SQLSACT (11/27/2012)

---

arkiboys (11/27/2012)

---

Hi,

Here is the database settings:

There is domainName\users unders security\ logins.

db_owner is NOT checked for database1

Then I go to database1, security\users.

I only see users. Notice that it is not...

does...

Guru Nagabhushan (11/23/2012)

---

arkiboys (11/23/2012)

---

Hi,

How do I make the users group i.e. domainname\users to be able to only select from tableA but user1 and user2 to have full control on it?

Note...

How can the logins and...

Thank you

Perry Whittle (11/19/2012)

---

No, write to a new file each time with a unique name

arkiboys (11/19/2012)

---

2-I am thinking of having t he full backup of the...