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 |
|
EdGruberman
Starting Member
2 Posts |
 Posted - 2005-03-07 : 13:36:03
|
| Hello all, I'm fairly new to DTS and UDFs, so I may just be making a silly mistake. However, I figured I'd see if anyone here might have some experience they may be able to lend a hand with.Basically I have a package setup that'll do your standard DTS copy of all objects from a remote database to a local one. However, I get the following error during execution:"Invalid object name 'dbuser.UINT2toSINT2'"When I check the UDFs in the remote database there is a 'UINT2toSINT2' owned by 'dbuser'. However, in my local database there is a 'UINT2toSINT2' owned by 'dbo'.Why didn't the same owner copy over also? It copies the owners the same for my tables, views and stored procedures just fine. Some are 'dbuser' others are 'dbo' and they all match as the remote database, except for the UDFs.I'm not sure why some objects have been designated as different owners in the remote database. It's a hosted database that I'm only a user on (but an owner for my database) so I'm not exactly sure why different owners are associated for different objects. I would think my 'dbuser' would be owner for anything I create no matter how I create it. But maybe that's a piece to the puzzle to? How exactly are owners assigned by default?In the end I just think DTS isn't copying the owner attribute appropriately or maybe it's doing it differently than everything else? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-09 : 01:15:24
|
| Are you running your DTS package interactively? Or are you scheduling it to run from the SQLAgent scheduler? If you run it interactively (from your logged in session in DTS designer), everything will run from the context of your logged in user account.What rights do you have in the destination database? If you are not a DBO user you won't automatically create objects owned by the dbo user.-ec |
 |
|
|
|
|
|
DTS Copy User Defined Functions Change Owner