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 |
|
jrockfl
Posting Yak Master
223 Posts |
 Posted - 2005-02-24 : 09:10:45
|
| This just started happening.Invalid object name 'ARSLMFIL_SQL' when I try to execute a query.This is the table, when I open it in EM, it adds my username likeSELECT *FROM username.ARSLMFIL_SQLAny ideas? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-02-24 : 09:30:00
|
| try...SELECT * FROM dbo.ARSLMFIL_SQLhave you changed SQL login method recently?....NT Auth to SQL...or trusted roles, etc? |
 |
|
|
jrockfl
Posting Yak Master
223 Posts |
Posted - 2005-02-24 : 09:39:41
|
| Yesterday I was trying to use profiler, and it said i needed to be a member of sysadmin, so i added that role to my login. could that be it? |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-02-24 : 10:36:30
|
| You are going beyond my level of expertise in this area...but (temporarily) reversing that last step/process might point to the problem. |
|
|
|
jrockfl
Posting Yak Master
223 Posts |
Posted - 2005-02-24 : 10:45:13
|
| The problem is with username.tablename so I did DTS to create all of the tables so they are nowdbo.tablenameMy SPs were not working either, so I created them all so they are dbo.spIf i execute a dts from my client machine, it will create a new table with username.tablenameI need it to be dbo |
|
|
|
|
|
|
Invalid object name - Help quick