Originally Posted by sknake

Sure you can. What I would is import the .CSV file to another table then:

Originally Posted by sknake

Open Microsoft SQL Server Management Studio, expand the server, expand database, Right click on the database --- Tasks --- Import Data, Click next, for choose data source pick "Flat File", navigate to the file, and away you go

Originally Posted by sknake

Sure you can. What I would is import the .CSV file to another table then:

Help with Code Tags

sql Syntax (Toggle Plain Text)

SET IDENTITY_INSERT dbo.Email ON
 
INSERT INTO Email (IdentityColumn, EmailColumn)
SELECT IdentityColumn, EmailColumn
FROM NewEmailTable
WHERE
NOT EXISTS
(
  SELECT *
  FROM Email (NOLOCK)
  WHERE Email.IdentityColumn = NewEmailTable.IdentityColumn
)
 
 
SET IDENTITY_INSERT dbo.Email OFF

SET IDENTITY_INSERT dbo.Email ON Insert Into Email (IdentityColumn, EmailColumn) Select IdentityColumn, EmailColumn From NewEmailTable Where NOT EXISTS ( Select * From Email (NOLOCK) Where Email.IdentityColumn = NewEmailTable.IdentityColumn ) SET IDENTITY_INSERT dbo.Email OFF

You can use that to match identities but more than likely depending on if you had activity before/after the delete and whether or not your table was truncated (which would reset the identity seed value) you may have overlapping identity values with different email data. In this case you could use the same query but test to see if the email exists, and not the identity.

I hope this helps and good luck, data recovery is never fun.

Originally Posted by oddvalue

I don't have that option in my menus. I'm using Microsoft SQL Server Management Studio Express 2005.

Any other suggestions?