If you take a look at the Microsoft example database called AdventureWorks, it has a very similar structure to what you're looking for:

http://msdn.microsoft.com/en-us/library/ms124438%28v=sql.100%29.aspx

Specifically look at the HumanResources.Shift, HumanResources.Employee

You need separate...

Check the permissions on the objects with DENY

select p.name, p.type_desc,OBJECT_NAME(dp.major_id),OBJECT_SCHEMA_NAME(dp.major_id), dp.permission_name, dp.state_desc

from sys.database_permissions dp

inner join sys.database_principals p on dp.grantee_principal_id = p.principal_id

where dp.state <> 'G'

Edit, actually it'll be the DENY at...

You probably wont have much luck unless someone else has used wildcard certificates on 2012.

Try resolving the error, this thread has a solution (for SQL2005) at the very...

That would work, except if S\AI is a member of any other Windows group that exists on the SQL server which has a DENY on ALTER, then he will still...

It has to be a permissions issue. The service account running the agent would only have limited permissions (as is best practise). You should probably try installing with...

I'm curious what the rest of the community does in your own environments. Specifically, these are the major changes I'm initially looking at process for:

- SQL Server installations and removals.

-...

What does the Windows Application log say?

Is IpAll Dynamic Port set to 0 on the instance? Or is it set to the same port as default instance?

What database status do you get from

select name, status from sys.sysdatabases

Not sure about the locking issue, but you could use sysinternals process explorer to check what is causing the...

One of the groups will have a DENY permission on ALTER or similar.

DENY takes precedence over any GRANTed permissions

For the databases in shutdown mode, check that Auto-Close is set to OFF, unless you're using SQL express.

For the random file locking, do you have a file backup system locking...

You only need to create an Alert with notify operator:

http://anyrest.wordpress.com/2010/11/25/create-alerts-for-sql-server-mirroring-failovers/

Or if you want to use a SQL Agent Job:

http://www.mssqltips.com/sqlservertip/1859/monitoring-sql-server-database-mirroring-with-email-alerts/

Alerts are designed for this situation though.

No, http://msdn.microsoft.com/en-us/library/ms173763%28v=sql.105%29.aspx

Least amount of IO:

http://www.sqlskills.com/blogs/paul/post/Which-index-will-SQL-Server-use-to-count-all-rows.aspx

What about adding a new BIGINT column with NULL default so theres no locking, populate with values via script in batches.

Then have a short outage while the new column...