That was it. It turns out that when the maintanance job was running, it detected the table in one schema, thereby bypassing the create statement, then attempted to...

That should be apparent when running

select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME = 'FRAGResultTable'

Shoudn't it?

I would think if you could locate a SQL 2005 install disk you could run the installer and select an uninstall option to remove the instance.

But if it were me...

If the SQLServer Service account is set during the initial install, or using the SQL Server Configuration Manager, shouldn't it have write access to all the drives, or at least...

Last year our application was throwing this error when we knew for a fact the SQL server WAS up & online. We eventually traced it to a configuration...

My workaround has been to build a virtual machine running Windows Server 2008 and install SQL Server there. You can connect SSMS to the instance on the host...

Perry,

I'd like to have multiple VMs, but my motherboard is limited to 4GB, I don't like running a Server 2008 VM with less than 2GB, and I'd prefer to use...

Thanks Thomas.

The trick was to turn on SQLBrowser on Windows 7. After that I was able to connect to 192.168.0.5\SQLEXPRESS from the VM. Curiously,...

Yes, TCP is enabled on SQLExpress, and windows firewall is off on the host and the VM.

Dan

A couple of years ago a bad SQL service pack upgrade on a 2-node SQL 2005 cluster led to both nodes having to be reformated and rebuilt from the OS...

Once you verify the service is running, check the instance name on it.

Can you not build a VM with the same OS as the old server (hopefully Windows 2000) and install SBS/SQL7 there? You may be able to use VM...

Have you tried the Visio Database Reverse Engineer feature? It creates a diagram and tries to show relationships- probably not all correct in your case, but it's a start.

Do...

Code can be impeccably reviewed, verified to be syntaxully correct, efficiently optimized and thoroughly documented, but if does not return exectly what the end user needs, it is still wrong.

How good in the communication between the end-users of the reports, and the developers, who can develope the query correctly only if they completely understand what whe end-users are seeking?

In...