Examine how roles play a part in keeping SQL Server secure. Most SQL Server databases have a number of users viewing and accessing data, which makes security a major concern for the administrator.

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 ...

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. Even though they typically use the same name they are ...

It is possible to write SQL directly in a script on your server used to generate content ... website in response to data from a SQL database or various user interactions. If you want to display ...

To rebuild a corrupted master database, you must run an instance of SQL Server in single-user mode, which prevents multiple clients from connecting to the server at the same time. You can ...

Ok, for SQL server 2000, I need to change the account it runs under. <BR><BR>I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab ...

You can see from the above example that I am passing the T-SQL query "SELECT * FROM Users" which is retrieving all rows from the Users table in the database myazuredatabase which is located on the ...

Types of SQL Server Database Corruption SQL page-level corruption: page-level corruption occurs when the information or data stored in the header, body, or slot array of a database page is altered ...