One question, was this database upgraded to SQL 2005 from SQL 2000 or from SQL 7?

Methinks badly behaving application.

It won't be the first time I've seen an application that went and fiddled with the system tables on SQL 2000.

Steve Jones - Editor (8/11/2008)

---

The point of my editorial (not sure about the experiment) isn't the Vista is or isn't good, but that people have those perceptions, not knowing anything....

That's the best, preferred and recommended way to fix corruption.

Are you sure about that? The objectIDs look too high for system objects (which is what type S...

Have a look at this entry on Paul's blog. It may help you

http://www.sqlskills.com/blogs/paul/2008/06/12/TechEdDemoUsingTheSQL2005DedicatedAdminConnectionToFixMsg8992CorruptSystemTables.aspx

Just be very careful and make sure you have a backup before you start. It's easy to break...

Update the statistics of any database that you upgrade from SQL 2000 to SQL 2005.

Nope. DB was completely unrecoverable, despite several hours of...

Something like this should work. Haven't tested.

SELECT col1, col2, CAST(NULL AS int) as AddedCol1, CAST(NULL as varchar(100) as AddedCol2, col3, col4 INTO SomeOtherTable

FROM SourceTable

Yup.

Looks like DOMAIN\bkumar doesn't have login rights on SQL Server. Just because its a local administrator doesn't mean that it has login rights to SQL.

Go into the SQL logins and...

I don't quite understand the question. Elaborate more please?

Adam Zacks (8/11/2008)

---

I have worked with some systems before where there is barely enough disk to run the db's and logs and backup the db (locally) before deleting the previous...

The login is a server-level principle. All that gets you is access into the server and (possibly) rights to server-level objects and permissions (logins, linked servers, jobs)

The database user links...

Or my semi-rant on the matter - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/