in reply to perl and switching between different version servers
"My problem is I've been left with a perl script by the programmer and the following directions:"switch from sql server 2005 to sql 2000 to run the perl script."
So are you currently running SQL server 2005? Does this code actually work as you expect it to? Have you considered asking the programmer who wrote this for an explanation of this? I don't see any SQL which I think would require one version of SQL Server over the other. Could there be problems with the ODBC drivers/DSNs on your system?