Categoria: Microsoft

DECLARE @tableSchema VARCHAR(5) = 'dbo' DECLARE @dbName VARCHAR(50) = 'TEST' SELECT CONCAT('USE [', @dbName, ']') AS Obj2Drop UNION SELECT CONCAT('DROP TABLE [', TABLE_NAME, ']') AS Obj2Drop ---TABLES--- FROM information_schema.tables WHERE…

Prompt dei comandi: wmic path softwarelicensingservice get OA3xOriginalProductKey PowerShell: powershell “(Get-WmiObject -query ‘select * from SoftwareLicensingService’).OA3xOriginalProductKey”

---SQL Server 2008--- IF OBJECT_ID(N'[dbo].[nome_stored]', N'P') IS NOT NULL DROP PROCEDURE [dbo].[nome_stored] GO ---SQL Server 2008 R2--- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('[dbo].[nome_stored]') AND type in…

Per abilitare il sessionState in modalità SQLServer, accedere alla cartella C:\Windows\Microsoft.NET\Framework\<versione del framework> e lanciare il seguente comando: aspnet_regsql.exe -S <ip del server> -U <user id> -P <password> -ssadd

Aprire un prompt dei comandi con diritti di amministratore e lanciare il seguente comando: powercfg -h off

USE MASTER GO ALTER DATABASE DatabaseName MODIFY FILE (NAME = 'LogicalName_Data', NEWNAME='NEWLogicalName_Data') GO ALTER DATABASE DatabaseName MODIFY FILE (NAME = 'LogicalName_Log', NEWNAME='NEWLogicalName_Log') GO

Dim obj As new Object obj = Activator.CreateInstance(Type.GetType("percorso.nomeclasse"))

ALTER DATABASE 'NomeDatabase' SET SINGLE_USER WITH ROLLBACK IMMEDIATE; ALTER DATABASE 'NomeDatabase' SET MULTI_USER WITH ROLLBACK IMMEDIATE;

Protected Function Crc32(ByVal FileName As String) As String Dim _fileStream As New IO.FileStream(FileName, IO.FileMode.Open, IO.FileAccess.Read) Dim _sha1 As New System.Security.Cryptography.SHA1CryptoServiceProvider _sha1.ComputeHash(_fileStream) Dim _hash() As Byte = _sha1.Hash Dim _buffer As…

EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE GO DECLARE @Command VARCHAR(1000) SET @Command = 'dir c:\*.txt /b /s' DECLARE @FilesInAFolder TABLE (FileNamesWithFolder…