Viewing 15 posts - 1 through 15 (of 16 total)
Thanks 2nd solution is working .
TC Faheem
June 5, 2008 at 11:47 pm
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...
March 17, 2008 at 10:08 pm
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 :
March 11, 2008 at 5:39 am
Hi,
Please visit this :
http://www.simple-talk.com/sql/backup-and-recovery/pop-rivett-and-the-suspect-database/
February 26, 2008 at 4:37 am
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
--------------------------------------------------------------------------------------
February 25, 2008 at 5:29 am
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...
February 25, 2008 at 4:13 am
Hi ,
Try this :
select CONVERT(VARCHAR,getdate(),103)
February 15, 2008 at 5:02 am
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/
February 15, 2008 at 4:16 am
Hi DEVI,
u can mail me ,Please see my ID using profile .
February 15, 2008 at 4:10 am
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
--******************************************
February 15, 2008 at 3:16 am
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...
February 14, 2008 at 10:19 pm
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
February 14, 2008 at 10:02 pm
Viewing 15 posts - 1 through 15 (of 16 total)