Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 25, 2005

The SQL Server Web Data Administrator - Page 2

By Steven Warren

Creating a new database

In order to create a new database, simply click the Create New Database link and enter the name of your new database. For example, create a database called Databasejournal, as shown in Figure D. Once the database is created, you can manage the objects by choosing the appropriate task, as shown in Figure E.

You can also view the objects by clicking Server Tools | Databases and choosing the database that you want to manage objects on. For example, if we click Server Tools | Databases | Pubs, we can view all the tables by choosing the appropriate link. Next, we can create a query and execute it for information as shown. Finally, we can run a quick backup if necessary, as shown in Figure F.

Figure F

Exporting/importing a new database

Exporting and importing a database is just as simple as creating a database. Just select Server Tools | Export/Import and choose the database and objects. Once that is complete, click Export or Import as shown in Figure G. Remember to save the file to an appropriate place on your computer.

Figure G

Creating logins and server roles

You can quickly create a login by choosing Server Tools | Security and then clicking the Security icon. Next, choose the Create New Login link on the right side of the screen (Figure H). You can also add and edit server roles (Figure I) by choosing the Roles icon.

Figure H

Figure I


In the age of 24 x 7 Web sites with no downtime, a DBA often needs a way to perform tasks quickly when off-site. The SQL Server Web Data Administrator is very powerful and gives you the ability to do a multitude of things with your SQL Server remotely. I recommend that you download it and give it a try.

» See All Articles by Columnist Steven S. Warren

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM