You should create a SQL Server login that has access permissions to only the procedures you want to access. Then connect to SQL with that login. There may be a...
You should be able to link to the 2000 server with SQL 2005 as a linked server. Then create a stored procedure that queries data from the linked tables and...