I'm still working on this problem..

'Cannot load the DLL C:\Program Files\Microsoft SQL Server\80\Tools\Binn\tripleDese.dll, or one of the DLLs it references. Reason: 193(error not found)'

Has anyone faced this problem before??...

Ok. Thanks.

I've created the xp_crypto procedure in Master database and it got created successfully.( we have copied the 'tripleDese.dll' to the sqlserver/bin location on the db server).

And,...

Thanks again!

Thanks very much. It worked.

Thanks, all. I tried the below view and it worked.

create or replace force view text_vw (itm,

...

Is there a way to insert a record without the NULL value in the curr_datetime field? THe below trigger I used is inserting a record with NULL value and inserting...

I tried the below trigger:

create trigger test_trg

on test

for insert

as

declare @dt datetime

set @dt = getdate()

insert into test (num,curr_datetime) select num, @dt from test

Inserted...

Thank you very much, that helped me a lot!

Yes, I am aware that it is an option to change using alter column statement, but even then there will be constraints dependency on them, so I am unable to...

Thanks all for the suggestions. But, unfortunately we dont have backup tapes for August. And we are a development company and this is a development database, so I think this...

Thank you very much.

Thanks Sameer. Thats a good option in future. But I actually need to get the list of records got inserted from august till now. Is there a way I...

Thank you all for the different suggestions. It helped me a lot!

I tried redgate(trial version) and I am happy with it. But I am going to try other methods sometime...