Hi all,
In SQL Server 7, when Im trying to open a table (in enterprise manager) for which the user has previledges, it says that SQL Server error 18456 - Login failed. and it asks to login again. When I login again, it connects correctly.
Why is this so? The user has all the rights to view the table. Is there anybody to guide me out??

Cheers and thanx in advance

Parasu Raman