ps. all dbo tables were imorted from access. All the new tables since then were created via enterprise manager. hmmm.
Adam. > -----Original Message----- > From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 12, 2002 9:55 AM > To: CF-Community > Subject: OT: sql server 2k table ownership > > > 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. > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
