SQL Server 2008 has a ton of new DBA features, but if you really want to make this thing go, just crank out a little code. SQL Server 2008 is mostly in the domain of system and database administrators ...
Learn tips for administering SQL Server securely. Of course, you might not have a domain at all. In this case, each server maintains its own SID database of users and objects. If users want access to ...
Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...
It doesn't matter at this point whether the server login is a Windows or SQL Server account; they each need you to grant it access to the database. Returning to Enterprise Manager, drill down to the ...