Thanks for the prompt assistance everyone.

The SQL from Luke L suits my purpose, although the behaviour detailed in the thread pointed to by SQL Junkie is worth noting. For the...

You aren't the first to have fun with this, have a look at some of the responses in:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=258150#bm258223

and see if any of those responses help.

Steve.

If you want to update an SQL source the best way is to drop it first and then re-insert it. The easiest way to do this is to include the...

In BOL have a look at the entry for 'Pivot table' - it creates a cross-tab report displaying the data horizontaly instead of the normal vertical format.

Steve.

Another possibility is that you have other software attempting to access that database still running. Ensure there is nothing else running that may be attempting to connect to that database.

If...

Thanks for the reply Jo, but I've had to take a different approach to solve this. I managed to find someone who has had the same problem and apparently SPs...

This problem appears regularly and so there are a number of postings about it here and elsewhere.

If I recall correctly I used the solution from http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=225048.

Another posting is

I've had similair problems in the past and if I recall correctly used 'sp_attach_single_file_db' via OSQL.

Regards,

Steve.

Whoever is responsible for monitoring the database and controlling the backups will certainly need to know as there will now be a requirement for Log backups, and the Log File...

So is this still correct:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_61x5.asp

In this example MS show how to restore the Master database, and have 'Use Master' as the first command. However, it is the Master database...

At a recent TechEd conference Microsoft detailed a free conversion utility they have for converting Oracle databases to SQL Server 2005. Unfortunately that is about as much as  know but...

We do appear to be getting more of this type of boasting QOD recently and I think it is somewhat peurile.

QOD can be a very useful exercise and has certainly taught...

Oh it will crawl, of this I'm sure. However, it's to replace a report our users currently have posted to them so I'm hoping I can at least improve on that!...

If I recall correctly the error log stated it couldn't recover the master db and it was set to suspect, and that was pretty much it.

After the thirs time this...

Does the SQL Log File give any clues as to why the database is now Suspect?

We've had databases set as suspect when a corruption in the Db's Log File has...