When formatting a hard drive of a server that is going to be donated how can I be certain that the data is gone? Is there a program or application I can run? Is there a standard procedure for this? Or does everyone remove the hard drives?
I need to create 2 database roles(need to write the script for this task) databasename_dbo_reader and databasename_dbo_writer for all the databases on a server. I have tried the below Declare @databasename sysname SELECT @databasename = (SELECT DB_NAME()) exec ('CREATE ROLE'+...