You only need to rebuild index ID on table ID 50099219 - surely the downtime for that is a small price to pay for fixing the corruption?  You could schedule it...

Anders

Yes, shrinking a file reduces the physical space it takes on disk.  Without a shrink, the space that the deleted rows took will be available for more data...

Anders

If your database has a size limit of 10GB and you're always hovering near to that number, there's no point in shrinking it.  You won't get much back...

Use the REPLACE function. You'll need to work out what character is being used for line breaks - CHAR(13) or CHAR(10), maybe.

REPLACE(MyCol,CHAR(13),'||')

John

Is there any reason why you're using a RIGHT OUTER JOIN?  Updating the outer table of that join means you're going to be attempting to update rows that don't exist....

Please check the syntax of the UPDATE statement.  The JOINs go at the end, after the assignments, and you need a FROM.

John

I'm afraid you've just discovered one of the reasons why a SQL Server service account should be the account under which the SQL Server service runs... and nothing else.  If...

Have you tried querying SSISDB?

John

Then I'd guess that the user is also a member of a group that is explicitly denied permissions on the schema.  I'm sure you can expand the queries I posted...

If you run these two statements in the database in question, do you get any results?

SELECT * FROM sys.database_permissions
WHERE state_desc = 'DENY'

SELECT *...

You can query the backup tables in msdb to find out the size of your log backups.  Take the largest size of those, add a safety marging of 50% (say),...

Joel

I don't know why that is, but why have you installed SSMS 2014 instead of the latest version, available here?

John