[dba-SQLServer] can't specify database in DROP INDEX

Arthur Fuller fuller.artful at gmail.com
Wed Jun 17 07:41:29 CDT 2009


USE <dbName>
DROP INDEX <indexName>

hth,
Arthur

On Wed, Jun 17, 2009 at 8:26 AM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> Am I missing something?
>
> CREATE INDEX allows me to specify the database but DROP INDEX gives me an
> error message
>
> 'DROP INDEX does not allow specifying database name...'
>
> Please tell me there is a way around this.
>
>



More information about the dba-SQLServer mailing list