Sorry for the monday morning OT, but I have a small annoyance where some of my tables are owned by 'dbo'; and some of my tables are owned by the user I created for my ColdFusion odbc dsn. All of the tables are accessible just fine, but when they're displayed in CF studio using RDS, it sorts them by the owner and then by name. All the dbo tables show up, and then the custom user tables.
Does anyone know how to change the ownership of a table in SQL server? Looked through the books for about 30 minutes this morning, maybe somebody can help me out. Thanks. Adam. ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
