objects titled (dbo)

[jazminecat]

I edited one of my tables, and now the name says (dbo). It didn't before. Now that has also broken my views, and i can't even open them to repair them. Can anyone help?

thanks.

 

[danvlas]

Login as a member of 'dbo' role and you'll see everything.
Now you're probably logged in as a 'public' user.

Or...someone (a sysadmin perhaps) has moved you out of that role and now you have no privileges on the database.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jazminecat]

thanks, I'll talk to the other person working on it and see if he changed anything.