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 |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2005-09-08 : 14:44:23
|
| I'm using dts to transfer all object from by database HS_Webcalendar the same database on another machine. Just when the dts package is about to finish I get the error "Invalid Object name 'webCalendarNightly.dbo.User"I'm not even accessing this database (webCalendarNightly) in the dts but I'm getting the error. Any ideas as to why I'm getting thisSQLSERVER 2000 |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-09-08 : 15:05:08
|
becuase whether you think so or not... you are accessing it.Maybe you have a stored procedure or function that references another database?maybe others can answer better...Corey Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."  |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-09-08 : 15:38:57
|
| What about a View that references the other database?Instead of choosing Transfer All Objects, try opening the options and choosing exactly which ones to transfer.---------------------------EmeraldCityDomains.com |
|
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2005-09-08 : 15:44:02
|
| You guys/gals are so smart. That was it. I had a view accessing the other database. Thanks |
|
|
|
|
|
|
Resolved - Invalid Object Name (impossible)