>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.
Alter Table 'mytable' AlterColumn.'mycolumn' INT NOT NULL (or whatever). If the column is used in a constraint, you may have to drop the constraint first, then recreate it...