you are probably looking to move an object to the other schema. THERE ALTER SCHEMA command lets you move a schemaname.object name into a specific schema.

if i "develop"...

not sure if it is related, but back when i had 2008/R2 instances, i had the built in procedure sp_spaceused return the same error, because i had some very large...

Just checking the basics, but is there any chance that the server you are connecting to is an Express instance, and not Developer/Standard/Enterprise?
If it were express, I'd expect a...

he said he is getting this error:

that means he's successfully connected to an instance.
so that...

Luis you posted your solution between the time i looked again; your's works as well, thank you!

OK walking away and doing a mental reset let me see my issue, or at least come up with a working solution
i *think* i had two things going on. 

it could also be nested permissions in Active Directory too.

So The users in [OURDOMAIN\SomeUsers] Are in [OURDOMAIN\BusinessAnalysts], and  [OURDOMAIN\BusinessAnalysts] was explicitly granted access.

check that login's default database.
see if the database has been dropped/removed, or the user no longer has access to that database. in those cases, setting the default database to...

SSRS is a little wierd, you have to assign permissions in two places, at the site, and at the root folder, the screenshot here is from an older verison, but...

view server state? i guess you are trying to select info about the connection from sys.dm_exec_connections

stick with what i said, either sign the trigger or use EXECUTE AS...

the trigger is probably inserting into an audit table, right? and a normal end user does not have access to that table; it might be sending an email, or something...

correction: the above uses a simpler cmdexec instead of powershell to call robocopy or the DEL command. same thing, different island.

Here's a script that I actually use:
It creates a job on Development, which does an on-demand copy_only backup of prod, copies it to the right spot on Dev via...

functions cannot use dynamic queries; you'll have to use a procedure instead.

from your screenshots, I'd say you ran the installer, but did not install any SQL services, otherwise you would see them in the Services section you posted the screenshot of.