Hi Timothy,

monitoring 'execution count' for a while might help.

See this article by Gregory Larsen -

http://www.databasejournal.com/features/mssql/article.php/3687186/Monitoring-Stored-Procedure-Usage.htm

Good work, Mike. Handy image, Troy.

One thing to keep in mind when using INFORMATION_SCHEMA.ROUTINES to search through stored proc text is that it's limited to the first 4000 characters....

Create a UDF similar to Farrell's SP.

--Usage

SELECT column1, dbo.udf_StripNonNumeric(column2) FROM MyTable

CREATE FUNCTION dbo.udf_StripNonNumeric (@str varchar(100) )

RETURNS varchar(100) AS 

BEGIN

 DECLARE @retStr varchar(100)

 DECLARE @iLen int, @idx int

 DECLARE...

---QUICK AND DIRTY

DECLARE @tablename varchar(30)

DECLARE @colname varchar(30)

DECLARE @updateSQL nvarchar(1000)

SET @tablename = 'dbo.tblTest' --Table in question.

DECLARE crs cursor LOCAL FORWARD_ONLY STATIC READ_ONLY

 FOR 

  SELECT     name

  FROM         syscolumns

  WHERE     (id = OBJECT_ID(@tablename))

  AND...

SELECT     TransID, MemberID, DateOfTrans, Amount, TransType

FROM         Transactions

WHERE   TransID = (

 SELECT TOP 1 TransID FROM          Transactions T1

        WHERE  T1.MemberId = Transactions.MemberId

        ORDER BY Amount DESC, DateOfTrans DESC

)

Try using the <PRE> tag.

...<td><pre>Report data here</pre></td>...

First back up by issuing

BACKUP LOG {db_name}

WITH NO_LOG

Then

DBCC SHRINKFILE (MYDB_Log, 100)

where MYDB_Log is the logical log file name

and 100 is the target size in MB.

Lookup CONVERT in BOL.

SELECT CONVERT (varchar(10), GetDate(), 103) ...16/09/2004

SELECT CONVERT (varchar(10), GetDate(), 112) ...20040916

Lookup CONCAT_NULL_YIELDS_NULL in BOL.

SET DATEFIRST 1

DECLARE @dtToday datetime, @dtToday_midnight datetime, @dtFOW datetime

SET @dtToday = GetDate() --test '2004-09-13'

SET @dtToday_midnight = CAST(DATEPART(yyyy, @dtToday) AS VARCHAR(4)) + '-' + CAST(DATEPART(mm, @dtToday) AS VARCHAR(2)) + '-' +...