I needed to find out which columns within all tables in the database, contained a specific string of text. I therefore wrote a script to do exactly that 🙂
Month: August 2010
If you need to transfer the logins and passwords from one server or instance to another server or instance, please refer to this very useful article from Microsoft: How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008
If you want to be able to specify the sort criteria for the results returned from a stored procedure, based on a provided parameter, you might want to try using the “QUOTENAME” function.