[hemiras]

How can I find who deleted the record in the table in SQL Server 2008?

[Ionut]

I don't think MSSQL can (or wants) to store this information, but you can create a trigger on the table.
So, create a table MyTableHistory with the same structure as MyTable

 
CREATE TRIGGER trgDeleteItems
ON MyTable 
FOR DELETE
AS
INSERT INTO MyTableHistory --add a column for user id or put your logic here so that you have your desired data
Select * from deleted 

more information about triggers

Ionut

[baavgai]

I agree with the auditing trigger above. If you have to ask now, it's probably too late. You place such mechanisms in before need them.