2011-10-03 (first published: 2008-03-27)
5,718 reads
2011-10-03 (first published: 2008-03-27)
5,718 reads
This script will quickly generate DML to search all the tables in the current database for a given string. It could be modified to execute the generated code if desired. If you are running this in a
2007-01-23 (first published: 2007-01-04)
2,933 reads
This function was originally contributed by other visitors. Below is an example of a set based approach to the problem. This script requires a numbers table (see SqlServerCentral article http://www.sqlservercentral.com/columnists/mcoles/2547.asp for more details)Please note that this code is uses SQL2005 featuresEnjoy!Robert Caryhttp://tsqlland.blogspot.com
2006-10-20 (first published: 2006-09-18)
540 reads
By Steve Jones
SQL Monitor has improved a lot over the last couple of years. We have...
I was reading a SharePoint List using the “Get Items” activity in an Azure...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
If I setup log shipping for a database, and I want to do a...
Hi, We are using SQL 2014 version. The scheduled backup job is failing with...
Hello, I've a user database which I want to migrate to new server, so...