UPDATE: I was informed by an Oracle Database expert that starting with Oracle 12c, you can indeed have an identity column, and no trigger or sequence is required. The below post still applies to Oracle 11g and older. If most of your database experience is with SQL Server (as mine is), you’re probably used to … Read more
This is closely related to my last post, where we were searching for text in the data itself, but now we’re just looking to see if the text exists in the statements that create views or stored procedures. This has been tested only on SQL Server 2008 R2. If you do not have permission on … Read more
Almost a year ago, I had reason to write a SQL script that would search for text anywhere in a database. Since then, I’ve had reason to modify and enhance it. The modification was done primarily to support SQL Server 2000, which I still have to support. The enhancement was done primarily to support user-defined … Read more