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
文章整理：站长天空 网址：http://www.z6688.com/
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!
