SQL Server Express

1，连接Express的时候，由于默认是命名实例，所以需要用local/express来连接数据库。

2，Agent是不可用的，虽然看起来agent service也被安装了。

3, 另外express还有诸多限制：

• Maximum database size of 10 GB per database in SQL Server 2012, and 2008 R2 Express^[1] (4 GB for SQL Server Express 2005 and earlier; compared to 2 GB in the formerMSDE). The limit applies per database (log files excluded); but in some scenarios users can access more data through the use of multiple interconnected databases.^{[citation needed]}
• No SQL Server Agent service^[2][3]
• Hardware-utilization limits:
  • Single physical CPU, but multiple cores allowable^[4]
  • 1 GB of RAM (runs on a system with any RAM amount, but uses only at most 1 GB)