Thanks Chris. Yes, it is 1-way only. As the data exterally is not system critical I thought to simplify the administration internally of creating a DTS package that wrapped up the following: 1. truncated the external table 2. execute insert into....select Obviously this limits the recovery options but do you see this as being a […]
2003-06-25
It also depends on whether you have downtime, if you do, detach and attach may be the way, otherwise, you need to backup/restore or DTS.
2003-06-25
1 reads
quote: Here in Europe M$ seems to like holding conference in Barcelona. That should also be worthwhile. I've been to TechEd before and must say it's more about Windows and Exchange. If you're looking for SQLServer stuff PASS is definetely the better choice. TechEd is also a lot more expensive even if you have shorter […]
2003-06-24
Try this conn. string "Provider=sqloledb;Data Source=Srvr;Initial Catalog=DB;User Id=Usr;Password=PWD" MW
2003-06-23
1 reads
quote: ...my NetAdmin didn't have the tape running on that server because he "didn't know" I meant to have that server backed up when I included it in the list of servers to be backed up. I hate to be brutally honest but they call that blameshifting. Learn from not backing up your MDF and […]
2003-06-23
Without researching it too much... I can tell that SQL2K loves having a clustered index. On my test machine I had the same table scan results as you, but creating either of the indexes as clustered resulted in both the table scans changing to index seeks, with no hints required.
2003-06-22
2003-06-20
I prefer using DTS for any time ... DTS have a BCP insert task and have more sophisticated tasks which helps me in ETL processing.
2003-06-19
1 reads
I should have given you more information. Sorry. The SQL cluster we have currently resides on the SAN that will be replaced. The company I work for has done this a couple of times in the past and has always had problems with moving an active/passive sql 2000 cluster from one SAN to another. The […]
2003-06-18
Have not played with this much, but I think for the jobs you can make them owners of the jobs. By doing this they should then be able to manage those jobs that they own. Not sure about the DTS packages. I assume if they are the owners of the packages they will also be […]
2003-06-18
1 reads
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
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