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
SQL: Transfer Logins and Passwords to a new server
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
SQL: Sort results based on a Stored Procedure parameter
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.