Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
a_r_satish
Yak Posting Veteran
84 Posts |
 Posted - 2006-03-22 : 06:31:41
|
| Hi everyone,i want the details of the user who created the specific table,stored procedure, view and other objects.. Where could i find the relevant information. I want it in a query.Regards,satish.r"Known is a drop, Unknown is an Ocean" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-22 : 06:40:53
|
| select * from information_schema.tablesselect * from information_schema.routinesMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Table stored procedure,view => Created by details