Programing Reference For .Net,Java,C

  By the following method (available online): 

  So onto the Command Command Prompt! (Wooohooo) 

  SQLCMD.exe will be your friend to explore the Beta 1 build of SQL Express. Here's how: 

  — Open a Command Prompt 

  — SQLCMD-E-S servername \ instancename (eg SQLCMD-E-S guntherb01 \ sqlexpress) 

  — Select name from sys.databases 

  — Go 

  You'll find a list of the default databases in your SQL Express installation (master, tempdb, model, msdb). However, no sample databases - nothing! 

  So here's 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 db's: 
  — 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 this version does not include the full-text index 

Releated Articles

• Popuklar Articles