What is the most likely cause of this behavor with SQL Server 2005?
I run Management Studio Express, connect to my local database with "windows authentication" and see that I have 1 database, and 1 table called dbo.MyTable.
Running "SELECT * FROM MyTable" (and dbo.MyTable) shows it DOES exist, but is empty.
I re-run Management Studio Express, connect to my 1 database with "sql authentication" myLogin/myPassword and see that I have a dbo.MyTable.
Running "SELECT * FROM MyTable" (and dbo.MyTable) gives:
Msg 229, Level 14, State 5, Line 2 The SELECT permission was denied on the object 'MyTable', database 'master', schema 'dbo'.
Running some common vb.net code, using my SQL authentication myLogin/myPassword, shows that I can read/write to MyTable with no problem.... and the table contains 100s of good records.
Do I really have 2-3 different tables here? (I only need 1.) I really NEVER need to have "multiple tables, with the same name, but my different owners".
What's going on here?