For the last 7 years, we 've been deploying on Windows Server Core, and now more recently, Linux.

We don't have the opportunity for local tools, other than limited commandline based...

And it turns out this behaviour is "documented" in BOL

http://msdn.microsoft.com/en-us/library/ms176060.aspx

Looks like my offline copy hasn't had the change applied to it.

This happened to one of our customer facing products. The database wasn't exactly hacked, but it was effectively the same.

A subscriber figured out how to work trick the application...

Sorry, I made typo in my previous post.

There are no instances nodes under HKLM\Software\Microsoft\Microsoft SQL Server.

However, I did find it under:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1

It would appear that the 32bit version of...

It's a standard default instance...

Snapshots are supported on Developer Edition, not just Enterprise Edition.

Also, the call to master..xp_regread doesn't work with my x64 install. Can't find the path in the registry.

Support for the RTM (service pack 0) release of SQL Server 2005 finishes on the same day.

Dave

I had a similar problem, but trying to apply SSRS after SP1+hot-fixes had been applied.

in the end, I scheduled a weekend maintenance window, backed up the databases, rebuilt the server,...

In my dealings with Microsoft, as long as I can prove I actually own the licenses to match what's deployed (in a sense that the servers are deployed for production...

First off, I'm assuming that TableA exists

Can you post the DDL for the columns of the two tables?

Functionally the two editions are exactly the same.  There are no limitations, no timebombs.

If you really do want to replace it, backup master and the other databases to another location. ...

whereas my solution was to write an application in C++ which lets me use a placeholder in a sql file, and specify a tab delimited text file to provide the...

Ouch!  I've done over 100 SP2 installs (including the betas), and never once had the installer fail in such a manor.

Are you installing using local administrator account, or domain/enterprise admin...

Todd,

Are you getting an error during the installer phase, or after?  Does any kind of dialog come up?  I'm assuming nobody is trying to use the system while the update...

Which edition (Workgroup, Standard, Enterprise)?

What licensing model (per client or per Processor)?

Do you have a Select Agreement with Microsoft and if so, do you have SA (Software Assurance) on your...