The advice on SELECT generally refers to OLTP environments. For reporting, usually users have access either to the tables or through views if row-level security is being applied.

The reason...

You want to use a DDL trigger. DDL trigger looks for view creation and automatically grants the appropriate permission.

This isn't possible, because the actual password isn't stored (nor would you want it to be). A hash is stored, much as it is with Windows systems. Since it's a...

So there are two domains.

The domain your user account is in is obviously trusted by the domain where the service accounts reside. However, is the reverse set up? If...

You said Domain\dev and Domain\prod, is everything in one domain? In other words, it's not actually DomainA\dev and DomainB\prod?

I'm assuming you started up a command prompt running as administrator, correct? If you didn't you need to if UAC is turned on. Then start sql server from the command...

You're saying through ownership chaining the user has appropriate access.

As far as tying to a particular owner, no.

When you create a schema you should create the permissions then. While...

Out of curiousity did anyone set the reserved memory for the VM itself? This prevents the balloon driver most virtualization systems use to reclaim memory from telling the guest OS...

+1 to everything Gail said.

But then the app couldn't use the database, either. 🙂 It's hard to retrofit an existing app to use column-level encryption.

I would give a quick support call to Microsoft, but I don't believe changing the IP addresses for the physical nodes is an issue. If you're going to change the...

We aren't using it but we've considered it. I've had a pretty lengthy conversation about what it does and doesn't do with the folks at Citrix. It's primary advantage over...

Unless you are talking SQL Server 2000, if I am a Windows admin I can get right in by putting SQL Server in single-user mode from the command line. If...

If you know for a fact that you want every login that is granted access to the SQL Server to access this database and that's not going to change (or...

As said, syslogins is deprecated. It is included only for backward compatibility and shouldn't be used if you're not querying SQL Server 2000 systems. The difference betwen sys.server_principals and sys.sql_logins...