I found this answered my questions - http://www.geakeit.co.uk/installations/how-to-add-a-mysql-server-as-a-linked-server-in-sql-server-management-studio.html

Not in SQL 2000. Yes in SQL 2005/2008 though...

[url= http://www.geakeit.co.uk/2011/02/05/a-table-input-variable-in-a-stored-procedure-and-bypassing-must-declare-the-table-variable-msg-1087/%5D

http://www.geakeit.co.uk/2011/02/05/a-table-input-variable-in-a-stored-procedure-and-bypassing-must-declare-the-table-variable-msg-1087/%5B/url%5D

Yeah I wrote a post about this a while ago - essentially you need to form a dynamic sql statement by stitching together a string and then execute it.

See here...

I had this problem too when trying to take a database offline. See here for my full solution walkthrough...

http://www.geakeit.co.uk/2010/12/11/sql-take-offline-fails-alter-database-failed-because-a-lock-could-not-error-5061/%5B/url%5D