Are u able to login in Windows authentication mode?

You can write a DB trigger For delete statements and Stored the username,currentdate,Servername in another table ...Just look the Example

create trigger tr_delete_log on dbo.TableA --(Table where delete occurs)

for delete...

Hi Sathish,

Can u explain clearly what u want to knw?I think u have done mirroring.If you look at...

Dear parthi,

Sorry for my mistake. 128 and 134 are the ID's of Salary and DA.Can u specify how...

Hi chris.king..

I think there is no another way.Joining tables will not decrease the Performance.

Regards

varun R

www.sqlinfo.in

Can u please make it clear?

Hi,

SELECT Employeeid,max(Amount),receiveddate from table

group by Employeeid,receiveddate.:-)

Varun R

http://www.sqlinfo.in

Hi adiga,

Thanks 4 the replay.All the master tables are different and new id is generated.how is it possible to transfer all the transactions corresponding with these id's and the existing...

Hi adiga,

I want to know whether it is possible or not?.I am new to this current DB and as I...

Hi sarath,

Store it as varchar in DB

Regards

Varun R

Hi michielbijnen,

This is because the sql server datetime has a format 2010-08-02 17:27:54.590 ie YY-MM-DD, if u insert 13 on the month's space it will throw error.Change ur date format...

Hi sarath,

I think you can use Bigint,As u told the remaining datatypes like varbinary and binary will give hexadecimal values.

Regards

Varun R

http://www.sqlinfo.in

HI..

It seems like some Syntax error in ur SQL..Please go through once again.

Regards

Varun R

http://www.sqlinfo.in

Hi,

Please check ur DB datatypes and assigned datatypes whether it is matching.

Reards

Varun R

Dear paulwhite,

Thanks for this wonderful solution...Keep it up..Thanks my dear friends for showing interest in answering my question...(For all)

Regards

varun R