It's more likely to be a permissions issue. The service account that SQL Server is running under has to have permissions to read the file. Find out from...

How about:

bcp Testdb2.dbo.Activity in "C:\Documents and Settings\..\..\\Activity.xls" -c -t, -S Servername -T

If I recall correctly, index 0 is the heap in a table with no clustered index. So it looks like the data pages are messed up. Still, getting...

I'm not sure this is fixable. Do you have a good backup? Can you BCP the data out (I'm guessing not)?

how about:

delete sop10200 where sopnumbe = 'XXX1234' and (dex_row_id >= 001

...

What,exactly, are you trying to repair? Did DBCC return an error on an index? If so, could you please post the error returned. That will help the...

Is there a trigger on the table? Posting the table DLL and the code you were running might help.

Merge as in "Structures are the same and the data needs to be combined" or "structures are different and objects need to all be in a common database"?

If the former,...

Thanks, Gail. I learn something new every time I visit.

And sometimes, it depends...

For #1 (where is are the latest database changes recorded and what would you do to preserve that particular piece of disk?)

For #2, it depends. The...

Invention can be the Mother of Necessity. Someone invented a plug-n electric car. Now we need charging stations all over the country. Someone invented shared networks, and...

Do you build the BCP command line in sql, or are all the values always the same. If they remain constant, then invoking bcp from a step in a...

What's the reason this needs to be xp_cmdshell rather than just an invocation of BCP from the sql agent job via command line? If there is work to be...

If the SQL Server is running, those files will probably be useless in a restore. You can back up SQL Server files when the server is not running, but...

Doing O/S type backups of database files while SQL Server is running will not work. If you want to use Netbackup to back up your SQL Servers, you need...