Reset SQL Server autoincrement ID

-
 Use the following script to reset the ID to 0


DBCC CHECKIDENT (TabaleName, RESEED, 0)


-------------------------------- Regards Shashika --------------------------------------

Comments

Post a Comment

Popular posts from this blog

Nintex Forms : Print to PDF, hide the Control Buttons (Custom JavaScript Button)

-
Image
If you wants to hide the Save, Cancel buttons while you printing your Nintex form, please follow the bellow steps Add a new button to your form designer  Go to "Control setting" of the Button  Figure 1 : Custom Button Control Settings  Add the Settings as above in the Figure 1 Use the below code for the Client Click field :  NWF.FormFiller.PrintToPDF.PrintToPDF(); Add a CSS Class to the controls that you wish to hide during print command (Figure 2) Figure 2 : CSS Class Use the below CSS script on the form control settings Nintex Form > Settings > Custom CSS                 @media print {                 .myButton {                      visibility: hidden! important;                           }         ...
Read more

[SOLVED] The SharePoint Timer Service service terminated unexpectedly. Event ID : 7031

-
Image
The SharePoint 2013 Timer service terminated unexpectedly.  It has done this  34  time(s).  The following corrective action will be taken in 30000 milliseconds: Restart the service Login Name : System Source : Service Control Manager Event ID : 7031 Level : Error                                    Keywords : Classic User : N/A                                       Computer : MyDomain If you are getting above error. Try to do the following steps  1.  Clearing the configuration cache Stop the Sharepoint timer service Go to C:\ProgramData\Microsoft\SharePoint\Config\*GUID Back up Cache.ini Delete all the .xml file ( Do not delete the Cache.ini file ) Open Cache.ini (Edit with Nodepad) Replace the contents with the number 1 and save the file...
Read more

Building a Top Navigation Menu Component in Power Apps

-
Image
  Building a Top Navigation Menu Component in Power Apps Overview This is a Power Apps custom component designed to create a responsive and customizable top navigation menu. It supports nested submenus, company branding, and theming for enhanced user interface design. Features Dynamic Menu : Supports main menu items and nested submenus. Company Branding : Includes options for company logo and name. Customizable Theme : Offers configurable colors and styles for the menu and submenus. Responsive Design : Automatically adjusts based on screen width. Event Handling : Provides navigation and submenu toggle functionality. Technology Stack PowerApps : The platform used to create the application and design the user interface. Component Properties 1.  cusPropCompanyDetails Type : Record Description : Defines the company branding details. Structure : ={ CompanyName: "Your Company Name", CompanyLogo: 'MediaFileReference' } 2.  cusPropCompanyDetails Type : Table Description :...
Read more