"txt was encrypted" errors in Compare

dvomsaaldvomsaal Posts: 8
edited May 22, 2008 1:12PM in SQL Compare Previous Versions
I am getting "text was encrypted" messages when attempting to retrieve any of my Views, Procs or Functions. Not these are NOT marked as Encrypted in the database. Server: Windows 2008, SQL 2005. I've tried changing the compat. on the db to 8.0; no change. Note I used to be able to compare to this database before it was detached and re-attached to the new SQL 2005 instance under Window 2008.

Any ideas? This is killing me.

Comments

  • Sounds like we're having trouble reading the sys.syscomments table. Either it got corrupted while reattaching the database, or some kind of obscure problem with Windows 2008, possibly something to do with reading the text out of sys.syscomments in the wrong collation.

    I'll see if we have any Windows 2008 problems, and if you could send a database backup and/or the output of 'select * from sys.syscomments' on the troublesome database to [email protected] that might help me track down the issue.
    Software Developer
    Redgate Software
  • Thanks, Michelle; I have emailed a backup. The SQL Server is 64-bit; would that cause an issue? sys.syscomments.text seems readable in SQL Server Management Studio.
Sign In or Register to comment.