Register SQL Server BCP.exe utility

Dear All,

I am facing problem related bulk copy program utility. I have both SQL Server 2000 and SQL server 2005 installed on my PC. The current registered BCP.exe is of version 8.0. When i give command BCP.exe with database of SQL Server 2005 on command prompt it actually check the database in SQL Server 2000. The problem resolved if i the complete directry path is selected i-e C:\Program Files\Microsoft SQL Server\90\Tools\Binn. But i want to enter command on every selected directry on command prompt.

Regards

Haseeb Ahmad

I'm not certain what you're asking here - but if you want the 2005 version of BCP to be the default, change your PATH variable in the operating system to have the binary directories for SQL Server 2005 to be above the ones for SQL Server 2000. You can also create a batch file in the operating system to use instead of calling BCP.EXE that has the full path in it if you don't want to change the PATH variable.|||

Thanks a lot for your help. After changing the path in enviornment variable, the problem has been resolved.

Once again thank you for your cooperation.

Haseeb Ahmad