jwcolby
jwcolby at colbyconsulting.com
Wed Oct 7 07:23:52 CDT 2009
I am attempting to write a stored procedure that exists in a database of stored procedures. This stored procedure needs to create an index on a table in a database and table which are passed in parameters, update a field in that database / table, then drop the index when done. In studying the drop index syntax it clearly states "in the current database". Does SQL (the language) not have syntax for dropping an index in a table in a different database from the one the SQL statement exists in? Is it possible to use something like Use @DBName to cause this to work? Is there something else I should be doing (other than a different line of work ;) -- John W. Colby www.ColbyConsulting.com