CONNECT SQL is a right given to the user through the public role. (Database level - Security | Roles | Database Roles | public

The CONNECT permission can be removed...

Can anyone confirm that this is a comprehensive list of the permissions?

http://www.databasesql.info/article/124980796/

Integration Services

Default instance or a named instance: SQLServerDTSUser $ ComputerName

The service capacity...

This is an old discussion. It may still be relevant. Has anyone ever attempted to map the permissions required to create the ACL's and so on for these...

Seems like the problem arises when a new service account is given permissions / added on the server. The DTS is an admin function and occasionally there are reasons...

This post caught my interest because it is recommended that a compressed index be dealt with offline:

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

So to address the issue as to why one may want to...

SQL Server 2014 was released to manufacturing on March 18, 2014, and released to the general public on April 1, 2014. Until November, 2013 there were two CTP revisions, CTP1...

"the type initializer for '' threw an exception" is the error that is created when the redgatemonitor database is created on the server during the sql monitor setup process.

While not likely the msdb could have been restored from a backup that did not have the same logical name, you may wish to check on what logical name is...

Tom,

Mostly, by way of English language flow. It is simple to say "Show me the stuff that isn't there or show me what you've got IN there." No...

I didn't think I was actually blaming Microsoft. I may not be very clear when I state the deal as it appears to me. What I was trying...

I'll be the first to admit I took a sharp right turn here.

Still, very valid point ... "NOT IN" and "IN" opens itself up to SQL abuse. ...

Yep, you're right. So if you are using an "IN" or a "NOT IN" statement, not only is it faster to join than use "IN" or "NOT IN", make...

Maybe. I thought the point was that there was a third variable, in this case a null which compares as equal to all the values of the name so...

I'm coming in late on this question. It's been my experience the "IN" operator in SQL is EXTREMELY inefficient. The why it is inefficient - the "why"...

Did you ever resolve this? I have a similar situation. I'm on a VM where the firewall is turned on so I put in an exception for the...