Every user that’s added to SQL Server is automatically assigned to the public role—you don’t need to do anything. Database roles are applied to an individual database.

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

Nevertheless, it does offer a Web-based report authoring and end-user query tool based on Microsoft’s .NET framework—and designed to exploit SQL Server 2000 Reporting Services.