Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Rosko2000

    Windows 2003 Standard Edtion licensing

    Correct, they will be access a public website. There are areas where people would login and basically create a session but that is between .NET/ASP and the SQL server. Not NT authentication. It's really a matter of interpetation I guess.. I asked the sales rep about 3 different ways and he was...
  2. Rosko2000

    Windows 2003 Standard Edtion licensing

    I'am hoping someone can tell me if this is true. We are looking to setup a web server running Windows Standard Edtion with MS SQL 2005 WorkGroup (cpu license). I've been told my MS sales reps that in order to have a ASP/.Net based website that allows people to login (similiar to a hotmail, yahoo...
  3. Rosko2000

    Left join works in Access NOT in SQL 7

    You would think Access and SQL server would be a bit closer... anywho I've learn a lot today thanks!
  4. Rosko2000

    Left join works in Access NOT in SQL 7

    True.. Last question and I'm done for the day. UPDATE tbl_keeplist2 SET tbl_keeplist2.status = 'R' FROM tbl_keeplist2 RIGHT JOIN tbl_moddate ON tbl_keeplist2.ID = tbl_moddate.ID Returns UPDATE over nullable side of outer join query on table 'tbl_keeplist2'. Original SQL was...
  5. Rosko2000

    Left join works in Access NOT in SQL 7

    ok, figured it out.. I tried selecting the data in Query analyzer and no go on that. So I double checked and logged back in with what should be the correct user thats being called by the application server and this worked UPDATE tbl_keeplist2 SET tbl_keeplist2.status = 'D' FROM...
  6. Rosko2000

    Left join works in Access NOT in SQL 7

    Just tried it with different users and I still get the same Invalid Object Name... thoughts? I appreciate your persistence!
  7. Rosko2000

    Left join works in Access NOT in SQL 7

    Yes and there are records, I did notice that this table has a different Owner then the others. All tables except for two are listed with owners of DBO the others are listed with Homefinder which is the user created for that database. Would this have anything to do with it?
  8. Rosko2000

    Left join works in Access NOT in SQL 7

    I'm now getting Invalid object name 'tbl_keeplist2_daily'. UPDATE tbl_keeplist2 SET tbl_keeplist2.status = 'D' FROM tbl_keeplist2 LEFT JOIN tbl_keeplist2_daily ON tbl_keeplist2.ID = tbl_keeplist2_daily.ID WHERE tbl_keeplist2_daily.status = 'P' OR tbl_keeplist2_daily.ID Is Null
  9. Rosko2000

    Left join works in Access NOT in SQL 7

    This has worked for years in Access UPDATE tbl_keeplist2 LEFT JOIN tbl_keeplist2_daily ON tbl_keeplist2.ID = tbl_keeplist2_daily.ID SET tbl_keeplist2.status = 'D' WHERE tbl_keeplist2_daily.status = 'P' OR tbl_keeplist2_daily.ID Is Null But no luck in SQL 7 I get the following...

Part and Inventory Search

Back
Top