Posts

Showing posts from August, 2013

SQL server : Delete field description in order to allow a DB to be exported as a BACPAC file

Run the following query : --tables select 'EXEC sp_dropextendedproperty @name = ''MS_Description'' ,@level0type = ''schema'' ,@level0name = ' + object_schema_name(extended_properties.major_id) + ' ,@level1type = ''table'' ,@level1name = ' + object_name(extended_properties.major_id) from sys.extended_properties where extended_properties.class_desc = 'OBJECT_OR_COLUMN' and extended_properties.minor_id = 0 and extended_properties.name = 'MS_Description' --columns select 'EXEC sp_dropextendedproperty @name = ''MS_Description'' ,@level0type = ''schema'' ,@level0name = ' + object_schema_name(extended_properties.major_id) + ' ,@level1type = ''table'' ,@level1name = ' + object_name(extended_properties.major_id) + ' ,@level2type = ''column'' ,@level2name = ' + columns.name from sys.extended_properties jo

Access full clipboard history on a pattern locked Android Samsung Galaxy Ace 2

On locked screen, draw an incorrect pattern 5 times till the button ' Forgot pattern ?' appears. Click on this button. Click on the text box where the blinking caret is in order to make the text selector appear (you may need to click twice). Click on the text selector. And then click on 'Clipboard'. You can then see all the clipboard history of the user...! As far as I know, this hack is only working on Samsung Devices.