Database Cannot be opened because it is version 706. This server supports version 661 and earlier

When I tried attaching a mdf file using SQL SERVER 2008 R2 I got the following error:

"Attach Database failed for Server "XXXXXX"

Database cannot be opened because it is version 706. This server supports version 661 and earlier

Solution

This is because the database I was trying to attach is SQL Server 2012. The only way to resolve this is to Generate Script from SQL Server 2012 then run it in SQL Server 2008 R2. This needs to be done for data too.

Find all dependent objects in oracle

Yesterday I had a scenario where I need to find the objects that are dependent on a particular table in Oracle 10g. My friend Peter happily offered me the following code.

select *
from dba_dependencies dep
where dep.referenced_owner = 'TABLE_OWNER_NAME'
and dep.referenced_name = 'TABLE_NAME'
order by owner, name;

The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database

You will need to reset your encryption keys. To do that: 1.Open Reporting Services Configuration Manager and select 'Encryption keys' tab 2.Click 'Delete' in 'Delete Encrypted Keys' section: 3.You will need to reset all connection strings and db credentials for all your data sources

How to use crow feet notation in data modeling in Enterprise Architect

1.Right-click data-diagram and select properties (you can do it in the working area directly or through browsing the Project Browser).
2.Navigate to the Connectors tab.
3.On the right side you'll see a small section labeled "Connector Notation", there you select "Information Engineering"

Citing Sources: [http://stackoverflow.com/questions/6690495/using-crows-feet-notation-in-data-modelling-in-enterprise-architect]:

Icons used in Fiddler

What's the circular stop icon in fiddler denotes?

The default text coloring of the Session entries derives from the HTTP Status (red for errors, yellow for authentication demands), traffic type (CONNECT appears in grey), or response type (CSS in purple, HTML in blue; script in green, images in grey).

Icons and descriptions - http://docs.telerik.com/fiddler/knowledgebase/uiguide