Thank you for the Reply!.. my criteria is that we would have mutiple records (Start and EndDt's) in the @Table1 for single ID and also the same in the @table2....

Update : was able find the solution to import replication .bcp data file from the below approach

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/31390e12-1139-418b-bba8-24aac1a30c2b

Thanks,

Rembersu

Update : was able find the solution to import replication .bcp data file from the below approach

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/31390e12-1139-418b-bba8-24aac1a30c2b

Thanks,

Rembersu

Insert Into @Table (Id, StartDate, EndDate)

Select 'id1', '20081016', '20090531' Union All

Select 'id1', '20090601', '20090605' Union All

Select 'id1', '20090601', '20090606' Union All

Select 'id1', '20090607', '20090729' Union All...

Thank you Somuch!!!!!!

Thank you so much , really appreciate your help with this.

I have not come across the scenario where there are multiple records with the same start and enddates. that...

Thank you for the quick response.

if the StartDate are same then we need to pick the earliest EndDate

and If the EndDates are same then we need to pick...

Thank you very much. it work fine i have a problem when the StartDate=StartDate or EndDate=EndDate

like the data sample below

Insert Into @Table (Id, StartDate, EndDate)

Select 'id1', '20081016', '20090531'...

thank you i think i have to go with the full backup :crying: .no i don't have the T-log backup for the database.

Thank you Steve for the link. from the article

"Note that once a file is set offline, the only way to set the file online is by restoring the file...

Yes i am trying to set the lost ndf file offline. and try to bring the database online.

Thanks & Regards,

Rembersu

I think you can try giving the user only read,write,DDl-Admin previlige this will

allow the user only to modify by query. if you add the View Definition permission on the

database level...

Yes when we create a maintenance plan SQL server will create a SSIS package and SQL agent job which has all the step which we select in the "select maintenance...

Thank you Phil & Ray!

It works now i am to load the text file with caret delimited.

Rembersu

Hi Phil ,

when i try to create flat file connection i see only one column in the Advance tab in the flat file connection manager editor. have tried to...