10:18 PM

build-a-web-and-mobile-application-with-angular-and-nativescript

posted by Web tricksin angularangular cliNativeScriptNews2 comments

Build a Web and Mobile Application with Angular and NativeScript
Getting Started :
 npm install -g @angular/cli
npm install -g @nativescript/schematics
npm install -g nativescript ng new angular-nativescript-project ng add @nativescript/schematics      or one line command        ng new --c=@nativescript/schematics --name=angular-nativescript-project --shared ng g component about ng g c contactus ng serve tns run android --bundle tns run ios --bundle
--control
   
  npm i nativescript-ui-listview
   
  For Textbox, label,radio button,
  npm i nativescript-ui-dataform   

  For calender you can [.....]

Continue reading

11:01 PM

how-to-repair-a-suspect-database-in-mssql

posted by Web tricksin DatabaseSql Server1 comments

How To Repair A Suspect Database In MSSQL

Possible Causes

The database could have become corrupted.
There is not enough space available for the SQL Server to recover the database during startup.
The database cannot be opened due to inaccessible files or insufficient memory or disk space.
The database files are being held by operating system, third party backup software etc.
There was an unexpected SQL Server Shutdown, power failure or a hardware failure.

Solution: 

EXEC SP_resetstatus databaseName
ALTER DATABASE databaseName SET EMERGENCY
DBCC checkdb databaseName
ALTER DATABASE databaseName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB (databaseName, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE databaseName SET MULTI_USER [.....]

Continue reading