Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lane0618
Posting Yak Master
134 Posts |
 Posted - 2002-06-20 : 17:22:04
|
| I have a sp with the folowing code:select itemFROM mfgpro.dbo.ANAwhere item like '1234'The problem is that the table owner name changes depending on who runs the proceudure to recreate the ANA table. Unfortunaletly I have no control or influence of this process, so I have to find a way of dealing with owner name changing tables. (from dbo to username then back to dbo etc..) Any suggestions.Thanks!Lane |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-06-20 : 19:51:38
|
| Fix the procedure that re-creates the ANA table to explicitly state DBO as the owner. The statement would look like this:CREATE TABLE dbo.ANA ...That way, the table will always have the right owner name.I know, you said you don't have any influence, but really... if you can't get this fixed... you probably should go looking for another job with competent coworkers.Edited by - AjarnMark on 06/20/2002 19:52:57 |
 |
|
|
|
|
|
table owner name changes