CleverDog Wifi Camera Stuck on Adding Camera

Do you just purchase a new clever dog wifi home security camera.  Is it stuck on trying to add device?  The manual does not mention it, but your Wifi network security setting must be setup as WPA2 for the camera to work.  Most routers by default are setup for WPA which will not work.  Cheers.

SQL SERVER – Restore Database Backup using SQL Script (T-SQL)

Database YourDB has full backup YourBaackUpFile.bak. It can be restored using following two steps.

Step 1: Retrive the Logical file name of the database from backup.
FROM DISK = 'D:BackUpYourBaackUpFile.bak'

Step 2: Use the values in the LogicalName Column in following Step.
----Make Database to single user Mode

----Restore Database
FROM DISK = 'D:BackUpYourBaackUpFile.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:DataYourMDFFile.mdf',
MOVE 'YourLDFLogicalName' TO 'D:DataYourLDFFile.ldf'

/*If there is no error in statement before database will be in multiuser
If error occurs please execute following command it will convert
database in multi user.*/

Add a link to another file or website in jQuery lightbox

Need to show the thumbnail on the page and open a larger file in the gallery while still giving the user the option or downloading the orignal file or linking to another website. Well, here is the solution.

<a href=”images/image-1.jpg” rel=”lightbox” title=”<a href=’’>Google</a>”><img src=”images/thumb-1.jpg” width=”100″ height=”40″ alt=”” /></a>

But, that will show up in some browsers as a tool tip onmouseover of the trigger and looks strange when it does. So, this works out better:

<a href=”images/image-1.jpg” rel=”lightbox” onmousedown=”this.title='<a href=\’\’>Google</a>’;” onmouseout=”this.title=”;”><img src=”images/thumb-1.jpg” width=”100″ height=”40″ alt=”” /></a>