In my application, the connection string specifies the database. So, when I do database management, I do not have to specify the database.

However, when I have to do this:

EXEC sp_rename 'ReportApplication.Size', 'SizeTest', 'COLUMN'

...as this is calling a SQL Server procedure, do I have to prefix the first parameter with the database name?

I am using sp_rename here as it seems SQL Server does not support ALTER COLUMN. If there is a way to do it, let me know.