IDC资讯中心
按如下方法（网上查到的）：
so onto the command prompt ! (wooohooo)
sqlcmd.exe will be your friend to explore the beta 1 build of sql express. heres how:
– open a command prompt
– sqlcmd -e -s servername\instancename (e.g. sqlcmd -e -s guntherb01\sqlexpress)
– select name from sys.databases
– go
youll find a list of the default databases in your sql express installation (master, tempdb, model, msdb). however, no sample databases – nothing !
so heres an (unofficial) tip to get some sample data in sql express (finally, this post is way to long) 🙂
– download and install pubs & nwind t-sql scripts: http://www.microsoft.com/downloads/details.aspx?familyid=06616212-0356-46a0-8da2-eebc53a68034&displaylang=en
– sqlcmd -s servername\instance -e (or -u sa -p password)
– :r "c:\program files\microsoft sql server 2000 sample database scripts\instpubs.sql"
– :r "c:\program files\microsoft sql server 2000 sample database scripts\instnwnd.sql"
to verify you have successfully loaded the dbs :
– select name from sys.databases
– go
– use pubs
– select * from authors
– go
note that these t-sql scripts were designed for sql2000 (hence unsupported), but hey, they seemed to run perfectly on my sql express machine.
now start enjoying sql express 2005 beta 1 !!!
这个版本的sqlserver2005 express 不包括full-text index
