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 |
|
ewade
Starting Member
36 Posts |
 Posted - 2002-10-17 : 13:23:37
|
| Our network admin commandeered my SQL 7 box and gave me 30 minutes to move the data to a different server. I used DTS from a SQL 2000 with default options to move the databases from the 7.0 box. Now I am experiencing a strange permissions issue on the 2000 platform- even when logged on as sa, I cannot insert rows into any table that was moved via DTS. I can, however, modify existing rows. I've checked the permissions on the tables, and they are set to allow full access. Does anyone have any idea why this has happened?Never stop learning! |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-10-18 : 11:31:44
|
| Any errors? Do the files have enough space to expand? DBCC CHECKDB return any errors? |
 |
|
|
ewade
Starting Member
36 Posts |
Posted - 2002-11-04 : 14:45:29
|
| Nope- no problems there. And as long as I'm logged in at the server console, things work perfectly. Logging in remotely using either a Windows 2000 account or a SQL server account (even sa) the system will not allow row deletions or inserts.Never stop learning! |
|
|
|
|
|
|
Odd permissions issue with DTS