How to bypass SQL query warnings?

[Admin Matt]

I have a Visual Basic 6 app where I try to run the query "ALTER TABLE
TABLENAME DROP COLUMN FIELDNAME;" I get a warning and the query never executes. I run this query from SQL Server Managment Studio and I get
a warning but it still executes fine. How can I get this to execute
despite the warning in Visual Basic? Thanks.

[daniel aristidou]

I have a Visual Basic 6 app where I try to run the query "ALTER TABLE
TABLENAME DROP COLUMN FIELDNAME;" I get a warning and the query never executes. I run this query from SQL Server Managment Studio and I get
a warning but it still executes fine. How can I get this to execute
despite the warning in Visual Basic? Thanks.

Um not sure about vb6...try looking under the properties of the data connection
or dataset.