LinkedIn | FaceBook | Twitter
Have you ever forgot to set the database when you ran a query, filling the master system database with your user objects? And I'll bet you used the dbo user too, didn't you? Doh!
Here's a quick way to ferret those out so you can clean them up:
/* Find foreign objects in the master database Buck Woody - 2007 (with thanks to Jaco Schalkwijk)Note: help_text is a Microsoft Object even though it returnswith this script.*/
-- SQL 2000:
PingBack from http://insomniacuresite.info/story.php?id=5902