InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 00:51:03 GMT20http://www.sqlservercentral.com/Forums/Topic128029-185-1.aspxAshish (and all) --Please help.I saw the excellent article..."How To Find SQL Server ObjectsBy Ashish Kaushal, 2004/08/17 [url=http://www.sqlservercentral.com/articles/Advanced+Querying/howtofindsqlserverobjects/1446/]http://www.sqlservercentral.com/articles/Advanced+Querying/howtofindsqlserverobjects/1446/[/url] " ...but I am still stuck because the Sql login that I use to check for SP existence is only a member of the following UserMappings...public, db_datawriter...and, as such, that user does not have permissions to query sysobjects, or so it seems because such a query always returns a null result......so, is there a workaround?Please advise.Thank you.-- Mark KamoskiThu, 17 Dec 2009 06:58:11 GMTkamoskimhttp://www.sqlservercentral.com/Forums/Topic128029-185-1.aspxLot of typo's in the script, annoying.Thu, 27 Dec 2007 08:48:54 GMTFreeHansjehttp://www.sqlservercentral.com/Forums/Topic128029-185-1.aspxPer the sample script, you may want to place brackets around the ? in case you have database names containing periods, etc. There's also a couple minor syntax problems in the example (misplaced #) and quotes being translated into left/right quotes.Wed, 17 Aug 2005 08:04:00 GMTDon Schaefferhttp://www.sqlservercentral.com/Forums/Topic128029-185-1.aspx<P>Well I didn't know about sp_MSforeachdb, and I didn't know you could press F4 in query analyzer to get an object search tool, so thanks to both of you...</P><P>BR</P><P>David</P>Wed, 17 Aug 2005 00:55:00 GMTDavid le Quesnehttp://www.sqlservercentral.com/Forums/Topic128029-185-1.aspxWe have<FONT size=2><P>We have to appreciate this work ,this is going to be use full while we are going for development of access control portion of very large database applications.</P><P>For object search purpose the Object Browser of Query analyzer is the best way . It allows palce holders like LIKE statement (%,?,_…) in object name filed</P><P>Regards</P><P>john</P></FONT>Wed, 18 Aug 2004 00:18:00 GMTjohncyriachttp://www.sqlservercentral.com/Forums/Topic128029-185-1.aspxIt seems like the Object Search (F4) from Query Analyzer accomplishes the same goal with a nice UI for flexible searching?Tue, 17 Aug 2004 11:53:00 GMTwilliamhoos@yahoo.comhttp://www.sqlservercentral.com/Forums/Topic128029-185-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/AKaushal/howtofindsqlserverobjects.asp>http://www.sqlservercentral.com/columnists/AKausFri, 23 Jul 2004 15:59:00 GMTAshish Kaushal