Thanks, looks like a tally table is just what I need!

For example, I have a single competition entry for the following people that appears in this Entries table:

EntryID Email ...

Thanks all. Lost my email connection so had to take the plunge. Backed up the data files just in case, then uninstalled and reinstalled SQL Server for the default instance....

Thanks all. Lost my email connection so had to take the plunge. Backed up the data files just in case, then uninstalled and reinstalled SQL Server for the default instance....

I have tried using the rebuildm tool to rebuild the master database on the local instance. I found it opened up a window that says 'configuring server', which stays there...

I get a response saying it could not find the specified named instance LOCAL, and in the errorlog file I found this:

2004-09-13 11:48:44.38 server    Microsoft SQL Server  2000 - 8.00.760...

The user that starts the default instance is LocalSystem. I have changed this to Administrator, which is what the second instance is using too, and back again, but it is...

Sorry, I seem to have posted this in the wrong forum. I have reposted this question in the Administration section for all versions of SQL Server .