In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this ...

I have worked with SQL Server ... harder to apply permissions to each individual Database User Account than to a Database role with a meaningful name. We also have access to Server roles where ...

I'm trying to create a new database diagram in SQL Server so that I can refer to it ... At this point, I think it's the tool and not necessarily the user.<BR><BR>Are there any other tools out ...

We have covered things such as viewing the state of databases, backups and even creating SQL server logins. Today we are extending our look at user accounts by creating database users and then adding ...

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...