The whole table does not have to be updated everytime.

I also created a table:

if exists (select 1 from sysobjects where type = 'U' and name = 'CCSC_STAGE_UDEF')

drop table CCSC_STAGE_UDEF

go

create table CCSC_STAGE_UDEF

(STAGEchar(5)NOT NULL,

PROGchar(5)NOT NULL,

UDEF_VALchar(1)NOT NULL,

constraint PK_CCSC_STAGE_UDEF primary key (STAGE, PROG))

go

insert...

Thanks.

I tried it out on my test database. I change multiuser to restricted_user and it worked.

I just want to know what type of modification was done.(delete, insert, update)

Yes, I mean changes to the data or changes to the definitions and structures.

Thanks

Thanks for the information. I will try it and see what happens.

How can I saved my scripts as SSIS packages? This is my first time using SSIS.

I now see where I click on integration packages.

Thanks

When I clicked on new job I did not see integration services. I have scheduled my scripts to run daily, but I am not sure if I did it...

I am trying to run sql scripts from SSIS.

Thanks, I will try that.

Thanks for your response. I did set up my own profile.

I will have to do some more investigating.

Thanks for your reply.