This is a noob question but how can I update the client tools without affecting the server

the version of query analyzer is 8.00.194

John

I have thought about it for sure but I am unsure of how to implement it. How could I could I write the sql if the last name is...

Worked great thanks and for the tip about the aliases. I was doing this in access it will make my queries much easier to read

Thanks

Graham

Sorry for the miscommunication the trigger is working great. The trigger will capture userid and session id when you created the trigger but will make it null if someone else...

As you can see from my post I am definate newbie but Im not sure I follow your reference to DELETED. I never explicitly created that table can I...

It is now working but the issue now is that when the trigger is called it just dumps all the records in from tblFeeStudent into the tblFeeStudentDelete

Ok I modified it now I get the following error

cannot insert a non-null value into a timestamp column

CREATE TABLE [tblFeeDelete] (

deletedKey int identity (1, 1),

[FeeStudentId] [udtId] NULL...

I was able to create the trigger no problem but when I go to test it causes the application to crash. here is the information getting passed into the delete...

I have had a tough time working through in how this could even be feasible but ideally I would have a result set of the date time format of day/month/year/hour,...