April 6th, 2005, 03:53 PM
|
 |
Contributing User
|
|
Join Date: Apr 2003
Posts: 114
Time spent in forums: 9 h 52 m 20 sec
Reputation Power: 9
|
|
|
i didn't know it did that but it makes sense.
if you want to fix that you have to change the owner of those objects.
this will display the list of tables and their owners.
select s.name, u.name from sysusers u, sysobjects s
where s.uid=u.uid and s.uid!=1
(s.uid!=1) excluding all objects owned by dbo
once you find the objects for that user, change ownership using this procedure.
change the owner to dbo
sp_changeobjectowner tablename,'dbo'
do that for all the user's objects or delete them.
Al
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
