Going back to the original question, you say that you think you're running 2005 because a 2008 script failed.

Could it just be that your database thinks it's still 2005, even...

Yes, correct on both counts.

Where it is...

How can no instances be running when you're connected and querying SQL? If you're connecting and running @@version, the service has to be running. Besides, I didn't ask what services...

Thanks, again (don't tire of reading this!).

For performance purposes, since I do not use SQL Server a lot, I have not set SQL services to launch at startup. A check...

I decided to check "Programs & Features" in my computer's Control Panel and the attached image is a screenshot of what I found installed under SQL Server. As you can...

I agree wholeheartedly. I suppose you do coding too so I shall be grateful if you could help me in the right direction:

If, by convention, database servers should be secured:

1....

Understood. Thanks a million. And, by the way, I was just stating the easy approach many developers go for, not saying that I do too. Since I joined here, I...

Thanks, Gail, for helping over the weekend.

Agreed, but as I...

I don't know what I may have I messed up during the install; of course I am not very expert on all the arcane options about named instances, pipes, etc....

Thanks, but that's exactly what I did the first time and it caused me this grief! It seems there is no guarantee that Uninstall does what it is supposed to....

Yes, I know what you mean. I used to do it the same way till I found out that uninstall does not remove everything. It actually keeps logs of every...

hallidayd (10/21/2010)

---

A named instance is not that big a hassle - why do you think it is?

If you are determined to have only a single instance, this is a dedicated...

Thanks. Now, I am certain I installed SQL Server 2008 R2 in full a few months ago. I may not have unistalled existing instances correctly, so how can I 'upgrade'...

Results from Help | About:

Microsoft SQL Server Management Studio 10.50.1600.1

Microsoft Analysis Services Client Tools 10.50.1600.1

Microsoft Data Access Components (MDAC) 6.0.6001.18000

Microsoft MSXML 3.0 4.0 5.0 6.0

Microsoft Internet Explorer 7.0.6001.18000

Microsoft .NET...

My God! What next? Could it be I am using SQL Server 2008 R2 and yet querying the version in Management Studio yields: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel...