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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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

Conclusion

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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date