Qualify tables in MSSQL with database and owner.

[lugnut]

Reactor.data.mssql.convention.cfc

The table and owner are known but not used in oo queries. A change to convention will allow the correct database and owner to be used.

change

<cffunction name="formatObjectName" access="public" hint="I format the object/table name" output="false" returntype="any" _returntype="string">
19 	                <cfargument name="ObjectMetadata" hint="I am the metadata to use." required="yes" type="any" _type="reactor.base.abstractMetadata" />
20 	               
21 	                <cfreturn "[#arguments.ObjectMetadata.getName()#]" />
22 	               
23 	        </cffunction>

to

<cffunction name="formatObjectName" access="public" hint="I format the object/table name" output="false" returntype="any" _returntype="string">
		<cfargument name="ObjectMetadata" hint="I am the metadata to use." required="yes" type="any" _type="reactor.base.abstractMetadata" />
		
		<cfreturn "[#arguments.ObjectMetadata.getDatabase()#].[#arguments.ObjectMetadata.getOwner()#].[#arguments.ObjectMetadata.getName()#]" />
</cffunction>

[lugnut]

This is an issue in SQL server 2005 where not specifying the owner can have implications if there is a table with the same name and different owners.