From: gofyself@wrong.address.com   
      
   "Erland Sommarskog"  wrote in message   
   news:Xns9DA3ACF51D933Yazorman@127.0.0.1...   
   > lk (gofyself@wrong.address.com) writes:   
   >> "Erland Sommarskog"  wrote in message   
   >> news:Xns9DA38092825DEYazorman@127.0.0.1...   
   >>   
   >>> Copy and paste both queries in a reply to this post.   
   >>>   
   >>   
   >>   
   >> select *   
   >> from HumanResources.Shift   
   >   
   > So this was the query that compiled. At least in runs on my machine.   
   >   
   > I think the query with the syntax error is more interesting. Verify   
   > that it gives any error before you post.   
   >   
   No - you misunderstand.   
      
   I have tried the query above twice in two separate windows - one works, one   
   doesn't.   
      
   It's as if one window is connected to the db and one isn't - but I don't   
   know how to establish the connection.   
   Therefore I had already verified that it gave me an error (invalid object)   
   before I posted.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)