You say that the error is on a certain line in a web script where there is a call to a stored procedure which is in "another database".

But is the...

So how does that piece of code look like? What line does the error message point to?

By chance, does the procedure have an EXECUTE AS clause?

Make sure that SQL Server is running.

Make sure that you actually installed it with the instance name SQLEXPRESS.

And make sure that you actually have SQL Server on the same machine...

I found https://connect.microsoft.com/SQLServer/feedback/details/797967/ssms-create-script-duplicates-the-statements-for-grant-or-deny-column-permissions and the response from Microsoft is that this has been fixed. I have not made research to see if the fix is included in any of the...

That is correct. If you have ALTER on a schema,...

I think the only reasonable way to achieve this is to create a schema for this purpose, and then grant the users CREATE TABLE permission on database level and ALTER...

Are these groups or logins in the AD?

1. Move all explicit object...

No, that was not the fix! That can be a huge security problem!

Setting a database as trustworthy is OK, if everyone who has db_owner or db_securityadmin access in the database,...

The question is not entirely easy to answer, and ultimately it depends on why you want to give developers VIEW SERVER STATE and how much you trust them.

With VIEW SERVER...

This question was also posted on the MSDN forums,

http://social.Msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/dac19eb7-fa4e-434c-82ef-3457a733403c#dac19eb7-fa4e-434c-82ef-3457a733403c

So all these child databases are all for the same client, and you have set of such databases per client? In that case, it certainly makes more sense.

But the child...

So these 10 databases have the same set of tables, with each database serving a specific client?

I am not sure that I think it is a wise move to put...

I don't what this xx_execprocs did, but maybe they had EXECUTE AS = 'xx_execprocs' in some parent procedure. As they grant EXECUTE permission, I suspect that they had a broken...

When you use EXECUTE AS for a stored procedure you impersonate a user, and when you impersonate a user you are sandboxed into the current database. There are ways to...

First of all, don't grant access the individual developers. Grant access to roles or Windows groups. If you grant the exec etc access to a role, all you need to...