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 |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2004-10-21 : 06:48:21
|
here it is rockmoose, if you have some undocumented xp's stashed away in your cabinets, please feel free to reply... --------------------keeping it simple... |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-21 : 12:35:22
|
| I offer the standard links with Alexander Chigrik's articles on sql-server-performance:extended procsprocsdbccChaos in my cabinet,/rockmoose |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-21 : 21:58:47
|
thanks rockmoose,you know i tried one xp,sp_MScheck_uid_owns_anything uid where uid - is the User ID, unique in this database. uid is smallint.This is the example to get the list of the objects, owned by the database owner 1 in the pubs database.and guess what, me thinks the xp is trying to drop the user, coz the error showed me...The user owns data types in the database and cannot be dropped.got pretty scared! then i remember, oh i was on my workstation and just working locally (whew).  i think this stuff is to be treated with extra extra precaution, as it's undocumented, i assume MS has reasons why it was so.--------------------keeping it simple... |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-10-25 : 04:19:34
|
Hi Jen,The mentioned proc doesn't drop anything, just raises "informative" errors.In EM if you have "show system objects" ticked then you can browse the code of ms procs,information_schema views etc.Very informative..raiserror(15183,-1,-1)raiserror(15184,-1,-1)raiserror(15284,-1,-1)raiserror(15421,-1,-1)exec master..sp_helptext 'sp_MScheck_uid_owns_anything' rockmoose/* Chaos is the nature of things...Order is a lesser state of chaos */ |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-25 : 05:04:05
|
quote:
The user owns data types in the database and cannot be dropped.
and i guess this is one of them? scary message though...--------------------keeping it simple... |
|
|
|
|
|
|
|
|
undocumented xp's please