Reset AutoIncrement field in SQL Server 2008 R2 / 2013

Solution: Applied to: Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 (but it’s similar for the other). To reset auto incremental field in SQL Server you have to execute the following query: DBCC CHECKIDENT (mytable, RESEED, 0) Best Regards, ITquadro – specialized Blog ITquadro consulenti informatici specializzati in ambienti microsoft sql server. Ci …

Reset AutoIncrement field in SQL Server 2008 R2 / 2013Leggi altro »

How to delete folder “this is no longer located in”

Problem: When you try to delete folder (i.e. ABB) on windows you receive “This is no longer located in D:\Cartella1 Solution: Applied to: Microsoft Windows (XP/Vista/7/8) Open CMD (command prompt) as administrator. Go to folder execute DIR/A/P/X Copy alias (ABB~1) and execute command to rename folder execute REN ABB~1 PIPPO Now, it’s possibile to delete folder. …

How to delete folder “this is no longer located in”Leggi altro »

How to shrink transaction log on mirror database (Microsoft SQL Server).

Solution: Applied to: Microsoft SQL Server 2008 R2 (but it’s similar for the other). To shrink transaction log manually on mirror database (Microsoft SQL Server) you have to follow these steps: Verify mirroring database: database must be in Principal, Synchronized state. Execute query: USE Databasename BACKUP LOG Databasename TO DISK = N’D:\Backup\DatabaseName_log.bak’ GO DBCC SHRINKFILE(‘DatabaseLogicalName_Log’, 1) …

How to shrink transaction log on mirror database (Microsoft SQL Server).Leggi altro »

Bring online database (access denied) Microsoft SQL Server 2012 BI – Accesso negato mettendo online un database

Problem: If you try to bring online a database and you receive “access denied” probably it’s possible, if you are an administrator with grant rights, that .mdf file doesn’t have right permissions. In my case the problem was NT Service/MSSQLSERVER or NT Service/MSSQLSERVER$IstanceName Solution: right click on .mdf file –> Properties –> Security — Edit –> …

Bring online database (access denied) Microsoft SQL Server 2012 BI – Accesso negato mettendo online un databaseLeggi altro »

How to activate Nessus on Backtrack 5 – Come attivare Nessus su Backtrack 5 ?

Solution: You have to register on http://www.nessus.org/register root@bt:~# /opt/nessus/bin/nessus-fetch –register code-that-you-receive-through-email Your activation code has been registered properly – thank you. Now fetching the newest plugin set from plugins.nessus.org… Your Nessus installation is now up-to-date. If auto_update is set to ‘yes’ in nessusd.conf, Nessus will update the plugins by itself. root@bt:~# nessus-update-plugins Fetching the newest …

How to activate Nessus on Backtrack 5 – Come attivare Nessus su Backtrack 5 ?Leggi altro »

Backtrack not possible to upgrade | dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1

Problem: When you try to install, upgrade o autoremove packages with apt-get you can encounter in the following error: Setting up se-toolkit (4.2.1-bt0) … svn: OPTIONS of ‘http://svn.trustedsec.com/social_engineering_toolkit’: Could not read status line: Connection reset by peer (http://svn.trustedsec.com) dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered …

Backtrack not possible to upgrade | dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1Leggi altro »

How to redirect non-www to www with .htaccess – Come redirigere non-www to www tramite .htaccess

Problem: How to redirect any requests from http://my-domain.com to http://www.my-domain.com. There are several benefits from doing that: Solution: Applied to: Linux apache. Log on your server and tries on website folder the .htaccess file and edit it: RewriteEngine On RewriteCond %{HTTP_HOST} !^www\. RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] Well done! Best Regards, ITquadro – specialized Blog ITquadro sistemisti specializzati …

How to redirect non-www to www with .htaccess – Come redirigere non-www to www tramite .htaccessLeggi altro »

The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)

Problem: When you try to delete user from database through Microsoft SQL Server Management Studio you might stumble in the follow error: “Drop failed for User ‘user’. (Microsoft.SqlServer.Smo).” “The database principal owns a schema in the database, and cannott be dropped” In simple terms, the user you want to delete has the property of one or more schema. …

The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)Leggi altro »