Active Directory, AS/400, Business Intelligence, Career Development, CIO, Database, DataCenter, Desktops, Development, Exchange 2003, Exchange 2007, Hardware, iSeries, IT Strategy, Linux, Lotus Domino, Lotus Notes, Management, Marketing Technology, Microsoft Access, Microsoft Excel, Microsoft Exchange, Microsoft Windows, Mobile, Networking, Oracle, OS, Outlook, Outlook 2003, Outlook 2007, Routers, RPG, RPGLE, SAP, Security, Servers, SQL, SQL Server, SQL Server 2005, Storage, Tech support, Virtualization, Visual Basic, VoIP, VPN, Windows 7, Windows Server, Windows Server 2003, Windows Server 2008, Windows XP VIEW ALL TAGS
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'+...