SQL Server has a long list of roles for server, database, and applications that outline things like permissions, data selection and modification, and disk management. Examine how roles play a part ...

I'm trying to create a new database diagram in SQL Server so that I can refer to it for relationships and that sort of thing. I opened SQL Server Enterprise Manager, created a new diagram, added ...

While we've covered how to add users to the database, let's take it one step further and designate specific roles.

I'm using Sql Server 2005 Management Studio on my client machine against Sql Server 2000 databases. For some reason, when I right-click to create a new diagram, the option isnt available.

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users.

You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server.