use [MyDatabase] go /* All NAV Versions */ delete from [dbo].[User] delete from [dbo].[Page Data Personalization] delete from [dbo].[User Metadata] delete from [dbo].[User Personalization] delete from [dbo].[User Default Style Sheet] /* NAV 2009 */ delete from [dbo].[Windows Login] delete from [dbo].[Windows Access Control] /* NAV 2013 ++ */ delete from [dbo].[Access Control] delete from [dbo].[User Property]