Hello wongj5, quote: Let's say I have 6 Word documents (Worddoc1.doc, Worddoc2.doc, Worddoc3.doc........) that have been uploaded into a SQL Server 2000 table. The name of the table is "Peter". I was wondering if there is a way I can rename all of the Word files with some code or script by appending the table […]
2003-06-10
I don't think so, but you'd have to try it. Not sure if there is anything in the multi-server code that would stop this. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-09
I do similar things in dts I would have the datapump task write a batch file and then execute the batch file to rename the file or files. So write your excel sheet to a generic filename and then from a sql server connection to a textfile destination use the datapump task. The datapump source […]
2003-05-26
You may encounter problem when try to backup the SQL Server databases that are being used. In order to backup open files like databases, you need OFM (open file manager) that is a component of most backup softwares. Or perform database backup to your local disk and use NT backup to backup the dataabses backup […]
2003-05-07
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers