Without even a transaction log file backup to go with, which I am surprised your company doesn't at the very least maintain these, you are out of luck.

Unless the user...

Try something like the following:

Use Master

Alter Database zReports

SET SINGLE_USER With ROLLBACK IMMEDIATE

RESTORE DATABASE mydb FROM DISK = 'x:\backup\mydb.bak'

WITH REPLACE

GO

I am not 100% certain this will work as the master db contains all user information, but if you use command line restore with single user tag, you should be...

What version, more importantly what service pack are you utilizing? If SQL 2005 SP2, this was a bug fixed with SP3.

No, there are three different versions of Developer edition. x86, 64-bit and 64-bitIA

ALTER TABLE InsertTableName DROP CONSTRAINT PK_Name

To reenable it:

ALTER TABLE InsertTableName ADD CONSTRAINT PK_Name PRIMARY KEY /* CLUSTERED */ (pk_column)

Is this error occuring during a job or maintenance plan? Have you attempted to run the command via query?

The main difference between 32-bit and 64-bit for Developer edition is the memory allocation or AWE switch is already enabled and you don't have the limitation like you do with...

Did you apply the cumulative update for SP2, we had the same issue when we did a migration a couple of months ago and just applied the cumulative update to...

They don't tell you this anywhere, but you have to stop the IIS Admin Service as well as the World Wide Publishing Service. After that you can install SP3

Good...

Take a look at this link, it talks about 32-bit SQL on a 64-bit OS, but the IIS install link is included.

http://msdn.microsoft.com/en-us/library/ms143293(SQL.90).aspx

Good Luck

Maybe I am misunderstanding your question, but to get the results from a query into a text file either execute the query by CTRL+SHIFT+F or change the setting via Query...

Yes, when you apply the SP it looks similar to an installation where you have all the available modules shown. Please make certain to check the SSRS module

I am not a real fan of renaming a server after installing SQL, but if you have done this in the past you know what to watch for. As...

"Do you mean you install sql server first, then restore databases, rename the computer, and then when you install ssrs, you got the hang up?" - Follow the steps in...