Another nostalgic post with SQL Server 2000. See my previous post on “Installing SQL Server 2000“.
I haven’t worked with SQL Server 2000 since I started working for EVRY back in 2010. Even then, collegues had a good laugh and taunted me for using old school development tools. I didn’t care because SQL Server 2000 was the tool the customer used for their front-end system, and it worked fine. But today SQL Server 2000 is not supported by Microsoft anymore, and I recommend customer that use this antiquity database to plan for an upgrade in the near future. The support ended April 9th 2013.
When I started the current project at work and logged in to the first server with SQL Server 2000, I had to think real hard to find the tools. But after a quick look at the menues, I recognized the two most common tools – enterprise manager and query analyser. Phuuu…
The screenshot below shows the Enterprise Manager (EM). This is a tool where you have a (nice) GUI for creating database and navigating through the databases on the server and do some simple tasks. The EM is not the best tool to work, and most of the work is done in the Query Analyser, descibed in the next section.
But the EM is simple to use and you create a database, user and grant/deny permission real easy while drinking coffie from your DBA cup 🙂
Creating a database
The first task is to create a new database. This example just include a simple database called ‘RoarTest’. As all other SQL Server versions, you can change the location of the data and log files. The screenshot below show the General tab where you name the database and set the collation. Use the server collation as much as possible.
The second tab – “Data Files” – enables you to select filename, location, initial filesize and which file group the data files should be placed. This is pretty much equal to the other SQL Server versions.
The next tab – “Transaction Log” – enables you to select the filename, location and initial size of the transaction log file.
It is the Query Analyse (QA) where most of the work is done. This tool is the predecessor to Managment Studio (SSMS). You have the database in the left pane together with templates for different operations that you use on regular basis.