SQL Server Performance Forum – Threads Archive

looking for script to list all the objects

1. From instance level, list all the dbs belongs to my account? 2. From database level, list all the database objects belongs to my account? ——————
Bug explorer/finder/seeker/locator
——————

---

Yes you can get that information if you can work out with SMO in SQL 2005, refer tohttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=175926&SiteID=1 fyi. 2. You can use SP_HELPROTECT on one database level for a login or list of logins. Kind of answered your own questionhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=18440 here. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

I think db objects are owned by schemas not the users any more!!! Mohammed U.

---

]]>