zhazhuzhao (6/17/2013)

---

I use this script to find which object the user have:

select 'select * from ['+s.name+'].['+o.name+'] where ['+c.name +']=User_ID(''LoginName'')'

FROM sys.all_columns c

JOIN sys.all_objects o ON o.object_id =...

I use this script to find which object the user have:

select 'select * from ['+s.name+'].['+o.name+'] where ['+c.name +']=User_ID(''LoginName'')'

FROM sys.all_columns c

JOIN sys.all_objects o ON o.object_id = c.object_id

join...

Hi, I got this error:

Msg 15183, Level 16, State 1, Line 1

The database principal owns objects in the database and cannot be dropped.

katukuri.sqldba (5/6/2013)

---

Hi there,

Did you note the error number,...

Hi, I have run this script! I didn't find it has relation with that user I want to drop!

It's only a database user from windows domain login! The login has...

Sure, I run it in the correct database!

SQLSACT (5/5/2013)

---

zhazhuzhao (5/5/2013)

---

SQLSACT (5/3/2013)

---

Can't remember where I found it, use this script to determine which objects are owned by the user

;with objects_cte as

(

...

Hi, also I tried this way, and the sql didn't return data! I check that...

SQLSACT (5/3/2013)

---

Can't remember where I found it, use this script to determine which objects are owned by the user

;with objects_cte as

(

select

...

Anyone can help is very appreciate!

Thanks!