[RESOLVED] VB 2010 - Renaming Columns in MSSQL Database

I am having an issue with renaming columns. My code is as follows:

Code:

---

Using m_cnInterval
    Using m_CMDInterval = New SqlCommand()
        m_CMDInterval.Connection = m_cnInterval
        m_CMDInterval.CommandText = "EXEC sp_rename '[" & strClassColumnName(intClassArrayPosition) & "]', '[" & strRenameClassColumn(intClassArrayPosition) & "]', 'COLUMN'"
        m_CMDInterval.CommandType = CommandType.Text
        m_CMDInterval.ExecuteNonQuery()
    End Using
End Using

---

I am getting an error message as follows:

"Either the parameter @objname is ambiguous or the claimed @objtype (column) is wrong"

I think this error is related to the way I am using my single quotes and brackets. Is there another syntax when using variables for column names?

Thanks

sp_rename requires TableName.ColumnName for the first parameter. I'm assuming that the array value returns just the column name (or if not the problem is in the second parameter which doesn't require the table name).

You are very correct. Thank you for your help!

I ended up with the following:

Code:

---

m_CMDInterval.CommandText = "EXEC sp_rename 'Interval.[" & strClassColumnName(intClassArrayPosition) & "]', '" & strRenameClassColumn(intClassArrayPosition) & "', 'COLUMN'"

---