Hi,

Just Try This

delete from t1 where custid not in                                                   (select custid from t2 where custype like '%employee%')

Rgds

Jey

Hi Arul,

Just try this

-------------------------------

create proc usp_databases 

as 

 set nocount on 

 declare @name sysname 

 declare @sql  nvarchar(600) 

 /* Use temporary table to sum up database size w/o using...

Hi Rama,

I aggry with Bill,its uppose to be in the order of

Full Backup,Differential bak,then Tlog Bak.

But is there any time difference for Full & diff,coz i took full on One...

Hi Bill,

I am 100% sure about the backup and norecovery,

but same time

i tried ,just taking the full backup & diff.backup in small time difference and try to restore,this case it...

Hi,

Actually  I had restore the full backup 1st then the latest differential backup i was trying to restore  while i got the error

Server: Msg 3136, Level 16, State 1, Line...

Is there any way to take a required size of the data extracted like how its work in VCD  Cuttter..?

Jey

Hi,

I did the same way...

Thanks Peter ,let me try