Click here to Skip to main content
15,905,875 members

Comments by NguyenVanDuc (Top 13 by date)

NguyenVanDuc 10-Oct-13 4:47am View    
BEGIN TRAN
USE [YOUR_DATABASE_NAME] --YOU GIVE DATABASE NAME FROM WHERE YOU WANT TO DELETE
Delete FROM YOUR_TABLE_NAME
--> it'll delete user of "YOUR_TABLE_NAME", not user login of database.
You can see users of database in Object Explorer in Microsoft SqlServer(Database --> Security-->Users)
NguyenVanDuc 10-Oct-13 1:31am View    
Delete FROM sys.database_principals --> it'll delete all user of all database, i want to setup where clause to delete users of ONE database.
NguyenVanDuc 10-Oct-13 1:07am View    
Thanks for your support,
This is query delete ONLY one user which we have NAME.
I want delete ALL user of ONE database.
NguyenVanDuc 1-May-13 12:04pm View    
the download file will not work again.
NguyenVanDuc 1-Nov-12 12:59pm View    
My link was generate only for an customer, nobody else can using this link for saving the download file. And this link is available in 2 hours.