My favorite tool ever in SQL 2000 was a little utility, a front end if you will for querying the system tables. It was under the tools menu and if you typed say 'account', you could find all objects containing the name 'account'- stored procs, tables, columns, etc. A GREAT little tool that few people seemed to use. Now I have 2K5, can't remember its proper name to google it by, and can't seem to find it anywhere, though I suspect it is burried somewhere.
Anyone seen this one in SQL 2K and remember its name, or better yet, seen it in 2K5 and can point me there?
Thanks in advance,
Jeff
Moving the thread to the Tools forum.|||I think you are thinking of object search, this is currently not part of the SQL Server 2005 toolset.|||Yep, that's the one...
Object Search. Dang I used that a lot, too bad they left it out of 2k5.
Do you happen to know is there anything similar in 2k5 to get the job done or is it down the querying the systables manually?
Thanks,
Jeff
sql
No comments:
Post a Comment