backing up SQL to local drive - 12-04-2004 , 03:46 PM
I created a DTS package to download my data off a shared SQL server. It runs
for a while then stops with an error. There's no such user as "bill". I
assume that it stopped because bill is an owner online, but not on my local
drive. Here's what I've tried...
1) I created a new user bill under BUILTIN/Administrators - still didn't
2) I tried only grabbing either tables or SPs - still didn't work
3) I tried unflagging all the user, permissions, login, indexes etc.
options - still didn't work
I tried changing owners, but it appears that doesn't work with shared
servers. I think I have to be part of the sysadmin or something.
What's left to try?
What am I doing wrong?