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

[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

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

FIX : stsadm is not recognized as an internal command

-
Image
If you try to run SharePoint STSADM.exe in powerShell and getting this error To resolve the error message you need to edit the profile.ps1 file Its located in C:WINDOWS\SYSTEM 32\WindowsPowerShellL\v1.0\ if the profile.ps1 file dose not exists, just create a new file and add the following code Set-Alias -Name stsadm -Value $env:CommonProgramFiles"\Microsoft Shared\Web Server Extensions\15\BIN\STSADM.EXE" Happy Coding  !!!
Read more