Assigning roles Let’s use SQL Server Enterprise Manager to add a Windows group to a Pubs database (a sample database that comes with SQL Server 2000) role.

In Project Properties, in the Project Settings tab, select the version of SQL Server that you're using from the Target Platform dropdown list. Now you need to add the database you're working with to ...

How to Attach an SQL Database to a Web Page. Your Web page can display up-to-date information dynamically -- all the time. And you never have to edit the page again. Attach your SQL database to ...

The holy grail of database development is the ability to treat database objects (tables, views, stored procedures, etc.) as if they were just like any other form of source code. While SQL Server ...

I did not need actual data; an empty copy of the latest database would suffice. I could easily add a few test records for the demonstration after installing the database on my laptop. I created a copy ...

There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

This code is used to add a new log file to the database using the alter database command. Method 2-Recover Database from an Existing Backup If you fail to rebuild the corrupted Log files, then you can ...

TechRepublic’s SQL Server newsletter, delivered each Tuesday, contains hands-on tips that will help you become more adept with this powerful relational database management system.