From: gofyself@wrong.address.com   
      
   Hi all   
      
   I'm using SQL Server 2005 express and the adventureworks sample database to   
   try and refresh my memory with SQL Server (It's been about 5 years since I   
   last used it a lot).   Can anyone help with a basic question...?   
      
   I've written two queries now - one works - one doesn't and I'm not sure why.   
      
   The syntax in both is identical (select * from HumanResources.Shift) but one   
   gives me an "invalid syntax near ." but the other works fine.   The only   
   difference in how I've written them is the one that worked I wrote by right   
   clkicking on the adventureworks icon on the object explorer.   The other one   
   I just did "File, New, Query with Current Connection".   
      
   Must be something fundamental I'm doing wrong.   Can anyone help?   
      
   Cheers   
   Rob   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)