Thanks all

Thanks 2nd solution is working .

TC Faheem

Hi,

The solution which I mentioned ,I only test on normal DB's but I hope this will also works only replicated db's for more details please see latest articles for replication...

Hi,

Plz make sure source file and target table column should be same and use this script :

BULK INSERT table_name FROM 'D:\file.txt' WITH (FIELDTERMINATOR = '\t',firstrow=1)

firstrow is optional :

Hi all,

Thanks for help full solution.

Hi,

plz visit this:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98017

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=51214

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1245854&SiteID=1

Hi,

Please visit this :

http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/

Hi,

Please try this 4 more information please visit :

http://technet.microsoft.com/en-us/library/ms162802.aspx

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

EXEC master.dbo.xp_cmdshell 'bcp fahtest.dbo.test out "d:\test.txt" -T -c', no_output

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

Hi ,

Please run this on your DB, This will be most easy and efficient solution .

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

exec sp_dboption 'DB_NAME','trunc. log on chkpt.','ON'

exec sp_dboption 'DB_NAME','AUTOSHRINK','ON'

checkpoint

BACKUP LOG DB_NAME WITH TRUNCATE_ONLY

DBCC SHRINKDATABASE...

Hi ,

Try this :

select CONVERT(VARCHAR,getdate(),103)

Hi,

ur trying to ask how we can fly Plane ,Answer should be in 1 line.-:)

Please read this:

http://databases.about.com/od/specificproducts/Database_Design.htm

http://en.wikipedia.org/wiki/Database_design

http://www.tomjewett.com/dbdesign/dbdesign.php

http://www.smart-it-consulting.com/database/progress-database-design-guide/

Hi DEVI,

u can mail me ,Please see my ID using profile .

Hi,

Please run this script on your DB, And sleep without tention-:)

--******************************************

exec sp_dboption 'DB_NAME','trunc. log on chkpt.','ON'

exec sp_dboption 'DB_NAME','AUTOSHRINK','ON'

checkpoint

BACKUP LOG DB_NAME WITH TRUNCATE_ONLY

DBCC SHRINKDATABASE (DB_NAME)

checkpoint

exec sp_spaceused

--******************************************

Hi K. Brian Kelley,

UR r8 ,one more thing i wanna add u can enable sheel option using.

EXECUTE sp_configure 'show advanced options', 1

RECONFIGURE WITH OVERRIDE

GO

EXECUTE sp_configure 'xp_cmdshell', '1'

RECONFIGURE WITH OVERRIDE

GO

EXECUTE sp_configure...

Hi,

Journeyman is r8 and version 2002 is not your SQL version number if u want 2 see your SQL version number please try this :

select @@version