I believe this is for SQL Server 7.0/2000 as it is under this forum. You can use DTS Import/Export Wizard or build a DTS package to transfer the data. Alternatively,...

As Phillip suggested, you may want to check the index stats. Use DBCC SHOWCONTIG to see if indexes are fragmented and consider rebuilding/defragging them. Another thing to look at is...

You have two options: Use OPENROWSET clause or create a Linked Server to the CSV file and insert into it like a normal table.

We had similar issues long time ago. Our task was to monitor if a service was still running. We used Sysinternals PSTools toolkit and created vbscript wrappers around them. This...

If you have access to extended stored procedure xp_cmdshell, you can use it to write to the text file. So you could use: exec master..xp_cmdshell "echo your_debug_statement >> c:\temp\temp.txt". You...

If you are looking to do this in T-SQL, you can create Linked Server to the Excel sheet or use OPENROWSET in your queries. Using both options, you will be...

Within SQL Server 2000, you have two alternatives:

1. Create Linked Servers to the Excel sheets and then access them like tables.

2. Query the Excel sheets using OPENROWSET method.

With the...

Can you please elaborate the target platform - is it Unix or Mainframe? When files are created on Windows, the default record delimiter is CR-LF. On Unix it is only...