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 |
|
tamartin
Starting Member
4 Posts |
 Posted - 2007-05-31 : 13:32:46
|
We have a DBA leaving and need to remove his NT login. The problem is he has been here for 5 years and there are many SQL objects including databases that were created with hims as the owner. How or what can be done to remove him and not distupt the SQL environment. We are running SQL2000 on Win2000 and Win2003 servers. Any help would be greatly appreciated. Note: for the time being we have change his NT passwords and marked the accounts to not expire. Also, I'm a SQL novice. Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-31 : 17:09:36
|
| Have to change object owner to other id, may need change related codes as well. |
 |
|
|
|
|
|
NTaccounts and SQL objects