Paul,

Below is the table definition:

CREATE TABLE [dbo].tableName(

column1 [int] NOT NULL DEFAULT (0),

column2 [varchar](8) NOT NULL,

column3 [numeric](10, 2) NOT NULL DEFAULT (0),

column4 [bit] NOT NULL DEFAULT (0),

column5 [numeric](8, 0) NOT NULL...

CEWII,

Exactly!!... I was expecting to see 3 or more different options from the forum and would pick the best 3 for test.

Ignas

CEWII,

I will try this approach and let you know the feedback..

Thanks,

Ignas

I will be grateful for the copy : ichilewa@gmail.com

Thank You

Thank you Roger your detailed response.

It is true that I wanted to see how people automate their unit testing strategies.

I've been testing my changes be in a stored procedure, trigger,...

Does it mean that people don't do unit testing or rather they decide to keep quite as they are not comfortable with this topic..

Someone come please, give me your experience...

Notification Services will be affected on both sql2k and sql2k5..

Please refer to the details and fix at http://support.microsoft.com/kb/931815/en-us

Ignas Chilewa

Dublin, Ohio

You can also think of using query to retrieve all records of interest  .. see sample below

select t1.a, t1.b, t2.c

from table1 t1 <left> join table2 t2 on

t1.a =...

Robert,

Thank you for your great idea, I like the idea of using checksum.

How expensive it is in terms of performance?

Ignas

Thanks Ninja for the great inputs.

I will sit down with my team members to try to digest these two possibilities, trigger and using a local copy.

Again thank you.

Ignas Chilewa

Dublin, OH

Yes Ninja,

Track changes of the data and not data types or otherwise..

Yes, I do have read access to this table and we would like to minimize duplication as much as...

Ninja,

I want to keep track of changes on one of n columns in this external table which has more than n number of columns.

Trigger has been ruled out as this...

You can also think of creating trace, filtering to an object you want to monitor changes, capturing t-sql and stored proc to the statement level.

Save the output to a...

You can also use the following script to accomplish the same request.

INSERT INTO tblBackupCourses

SELECT tblCourses.*

FROM tblCourses, tblGrades

WHERE couCourseID = graCourseID AND graStudentID = 'ID1'

AND not...

You can try this one :

-- start here

declare @output_param <data type>

exec BuildBookTitleFromTempTable @output_param output -- I'm assumming that you will modify ur sproc to include output param

update pubs

set booktitle =...