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 |
|
Jeremy D. Martin
Starting Member
2 Posts |
 Posted - 2008-03-14 : 16:34:33
|
| I have an appplication which creates triggers on tables. It works on nearly every table I have in my repository except for one. When I attempt to apply it to that one, I get the following:"The object TABLENAME does not exist or is invalid for this operation."I know the table exists and am able to access data in it just fine. So what are all possible reasons why CREATE TRIGGER might be an invalid operation for it? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-14 : 16:47:09
|
| Check the table ownership.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Jeremy D. Martin
Starting Member
2 Posts |
Posted - 2008-03-14 : 16:58:40
|
| How exactly?Is it possible for one table in a repository to have different ownership from every other table in the repository? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-03-14 : 17:42:27
|
| Yes that is possible. You can visually see who is the owner by using SSMS (2005) or EM (2000) by looking at the list of tables.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Table Does Not Exist Or Is Invalid...