NuGet Install Error

by MikeMaloney 6. February 2012 23:39

First uninstall nuGet, using Add/Remove programs.  If that does not resolve the Signature issue

Simply uninstalling with "Add Remove Programs" may not clear the problem up - it didn't for me. Try the advice for "Cannot uninstall NuGet for Windows Phone Tools" in the known issues document, which basically says:

Windows Phone Tools does not have support for the Visual Studio Extension Manager. In order to uninstall NuGet, run the following command.

vsixinstaller.exe /uninstall:NuPackToolsVsix.Microsoft.67e54e40-0ae3-42c5-a949-fddf5739e7a5

This worked even though the phone version had reported as being installed successfully, and the Visual Studio had been the one with the error.

Tags: ,

nuGet

SQL Server Reset Identity on Table

by MikeMaloney 1. February 2012 10:22

Occassionally I get requests to change the identity value of a table for a customer.  These requests are normally when issuing a Work order, or some sort of Job# when developing solutions.  In order to do so we use the DBCC command.  The DBCC command with CHECKIDENT accepts the arguments

1. Your table name that you want to reseed

2. RESEED  (reset the seed)

3. The Reseed value - The next identity will be this argument plus whatever your step value is.  By default it is 1 so the next identity will be 500.

DBCC CHECKIDENT ( ‘databasename.dbo.myTableName,RESEED, 499)

Tags: , , ,

SQL Server

About the author

Michael Maloney has been programming in ASP.net since version 1.0 and is an avid technology enthusiast.  His work interests inlcude ASP.net, SQL Server, AJAX, Jquery, TSQL, and Android programming.  He has also achieved certification as a Java Certified Programmer.

Month List

Page List