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)