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.

not sure what is going on in your case specifically;
i just wrote the attached stuff to explicitly check what my settings are in SSMS vs a TSQL  job, vs...

you did not show your entire query, so it's hard to diagnose.
review your code, because each and every EXECUTE(@SomeCommand) could be the potential problem. how many executes do you...

you are declaring a command and executing it. the internal command does not have the same settings for quoted identifier

Declare @command varchar (max)
SELECT...

a wordier version just like what Luis did;
i thought this way shows the advantage of actually storing the data correctly.
I added the three name examples from our other...

you can use this trick to join your table with a total against a Tally or Numbers table to generate each label you need.

it makes it a lot...

backup and restore replaces the entire database(meaning all existing data) with the new backup; since you are saying replace a range of data, from what you are describing, that's not...