sql server issues

  • I have created a table and i can see the data when query agianst that table.But in the enterprise manager i could not see the table even after i refresh the tables icon.What could be the reason and i have one more issue is that the createdate value of the table changed to '2003-4-18 17:54:25.790' FROM '4/18/2003 5:54:25 PM'.Its not for one single table.Its for all the tables in my database.

  • Did you create it with 'dbo' as the owner?  Do an sp_help and see who the Owner is.  If it's not DBO then maybe its a security issue and your aren't allowed to view it through EM.


    Darren

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply