Ruairi:
I've never used SQL Server 6.5, but in 7.0 the log file continues to grow until a transaction log backup, and maybe a complete database backup will do that too. So your log can grow out of control especially if you Database is used a lot during the day. I'd try doing a transaction log...
I need to dump data from a table to a comma delimted text file. I can do that.. the question is can I do it to a textfile with today's date in the filename.
For example would like to have the filename be
1-17-2001.csv and at 12:30am when the DTS runs the new filename would be 1-18-2001.csv (...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.