I had an issue in the past where a SQL server 2012 always on availability group would fail and cause SQL Server to crash with the error message "access violation".

This...

Hi,

The answer to the second question is because the sys.databases is marked as a system object meaning it can be called from any database, so no matter which database you...

SSIS running as a service is not supported by SQL express

https://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/

Ok you're right, I just tried also with a test login with db_ddladmin only and I was able to truncate a table and add a column.

You have to admit the...

I not sure that alter schema permissions means alter any object within that schema, I think it refers to the following:

https://msdn.microsoft.com/en-us/library/ms173423.aspx

The OP has already tried to alter a...

John Mitchell-245523 (2/11/2016)

Are you sure about that?...

According to this:

https://technet.microsoft.com/en-us/library/ms189612(v=sql.90).aspx

ddl_admin does not have alter table, it does seem to have alter everything else though.

Tbh I would just give the user db_owner and tell them not...

In Management studio, browse to security / credentials, right click on credentials and select create new credential, give it name and the user account and password you want to use,...

Not sure why you want to do that, surely setting all the same permissions as dbo would be the same as assigning the user to the db_owner fixed role?

Or is...

Good stuff, glad I could help

If it's not that... then....have you set up a "credential" and associated it with the agent proxy account?

I had a very strange error like this is the past, agent proxy account would fail with password is incorrect even when I was sure the password had been typed...

Could be a "send mail task" within the SSIS package. Check for a SMTP connection which will have that email address specified in the "from" box.

Seconded, I actually forgot to set this on a build I was...

I had a similar problem, mine would just ignore some backup files and delete others, I never did get to the bottom of it but I replaced the job step...