thank good for backups all I have to say

a company I work for has a administrator and he/she delete the content of a table Bugger I had rrestore 1 table only as data had added after a backup as done

heres what I did

1. trun off the SQL and copy the SQL files to a differnace place (backup only if it did not work)
2. them did the restore of the database
3. open up MSAccess and did a make table of the missing table data
4. copied back the old live database
5. turn the index autonumber off on the table that was missing the data
6. did a update of the data of the form the make table I created in step 3
7. turn on the autonumber and made it the key feild again

and it work

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[weekend] (@we datetime)
RETURNS datetime
AS
  BEGIN 
    RETURN DateAdd(dd, (-1 * Coalesce(NullIf(DateDiff(dd, 5, @we) % 7, 0), 7)) + 7, @we)
  END