That didn't work (but thanks for the suggestion). It did show up in the CTRL-TAB window, but still didn't appear when I selected it.

However, while mucking about with this,...

I do have the 2008 BOL on my desktop. CREATE INDEX is OK, but it's wrong in the "Implementing Indexes" section of "Designing and Implementing Structured Storage".

Just as well one of the answers wasn't 250, or I would have gone for that (1C + 249NC). I hit the wrong page in BOL first, and it's...

Didn't try a backup, but restore worked just fine. I can't see it being a disk problem since I can see everything OK in explorer - it's just SSMS...

I've always found http://www.sql-server-performance.com/ to be pretty useful.

With the help of trawl though the C: drive, I managed to find it. The details are stored in a (not especially readable) XML file "C:\Documents and Settings\MyUserName\Application Data\Microsoft\VisualStudio\9.0\ServerExplorerDefaultView.SEView"...

No, there isn't a log backup, only a log.

Since the question states "...using the log backups", and there can't be any in Simple mode, my reasoning was that the correct answer has to be "none of the above"....

BCP in requires the table to already be there (I think - I haven't actually checked), so you'd still need to have scripted the table before you made the changes,...

The problem with the backup solution is that you can only restore the entire database, not a single table (assuming you're using the standard MS tools). If there are...

Boo hoo :crying: - I got it wrong because my local copy of BOL (SQL 2005) doesn't have the (count) syntax in it.

I know you mention that your systems are VB6, but if you also do development on later versions (2005 onwards) of Visual Studio (I think it has to be VS...

In your DOS script, try something like this:

IF %ERRORLEVEL%==1 ECHO *** Failure creating SP1 ***

After each call of SQLCMD. We do something similar with OSQL (yes, I know it's...

They don't even have to be compatible versions. I'm running VS2003, VS2008 and BIDS, and they all run OK.

I have to admit I'm writing this without checking, but it's probably something like this:

If FileExists("C:\Test\" + i)

DeleteFile("C:\Test\" + i)

End If

File.Move(f,"C:\Test\" + i)