Posts have been few and far between this week. I'm taking a 5-day course on developing web applications on ASP.NET. More later on why an infrastructure “monkey” like me would be doing such a crazy thing...
The instructor just pointed us towards the web administrator for Microsoft SQL 2000. This is a great tool - I didn't even know it existed.
From the Microsoft Download Page:
The SQL Server Web Data Administrator enables you to easily manage your SQL Server data, wherever you are. Using its built-in features, you can do the following from Microsoft Internet Explorer or your favorite Web browser:
Create and edit databases in SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (MSDE 2000)
- Perform ad-hoc queries against databases and save them to your file system
- Export and import database schema and data
- Manage users and roles
- View, create and edit stored procedures
You can download the tool using this link: http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en.