Mansoor Lakhani

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.

CREATE USER <dbname>@localhost;

SET PASSWORD FOR <dbuser>@localhost= PASSWORD(“<db_password>”);

GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@localhost IDENTIFIED BY ‘<db_password>’;

FLUSH PRIVILEGES;

source <data_file>.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.
RESTORE FILELISTONLY
FROM DISK = 'D:BackUpYourBaackUpFile.bak'
GO

Step 2: Use the values in the LogicalName Column in following Step.
----Make Database to single user Mode
ALTER DATABASE YourDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE


----Restore Database
RESTORE DATABASE YourDB
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
mode.
If error occurs please execute following command it will convert
database in multi user.*/
ALTER DATABASE YourDB SET MULTI_USER
GO