RE: Unlocking a view

[allyne]

Hello everyone,

I was wondering if anyone has a script that will unlock a view. Unfortunately the person who created this lock is no longer with us and it is part of an excel dashboard. I'm trying update this view for the monthly reporting as it no longer works due to an upgrade.

Thanks for your help!

 

[bborissov]

What do you mean with "Lock"

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[allyne]

Hello,

Sorry. should have been more clear. The view within the database has a picture of a lock on it. It looks like it is encrypted and I need to decrypt it to update the fields. Hope this makes more sense.

 

[bborissov]

Check this:

http://www.mssqltips.com/sqlservertip/1046/decrypting-sql-server-database-objects/

Never tried it, so I don't know if it works.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[allyne]

Thanks for your help! I'll give it a try.