EXEC sp_rename 'tablename.oldindexname, tablename.newindexname', 'INDEX'

Don't forget the tablenames.

I'm always forgetting my dsn-less connection string formats.

VB6:

Oracle:

Provider=OraOLEDB.Oracle.1;Data Source=tnsname;User Id=userid;Password=password;

 

Sql Server:

Provider=sqloledb;Data Source=servername;Initial Catalog=dbname;User Id=userid;Password=password;

.Net

Oracle (OracleClient):

Data Source=tnsname;User ID=userid;Password=password;

 

Sql Server (SqlClient):

Server=servername;Database=dbname;User ID=userid;Password=password;Trusted_Connection=False