Kunal RanpuraJul 29, 20191 min readHow to Get SQL Server processor description from Windows Registry-- Get processor description from Windows RegistryEXEC xp_instance_regread 'HKEY_LOCAL_MACHINE','HARDWARE\DESCRIPTION\System\CentralProcessor\0','ProcessorNameString';
-- Get processor description from Windows RegistryEXEC xp_instance_regread 'HKEY_LOCAL_MACHINE','HARDWARE\DESCRIPTION\System\CentralProcessor\0','ProcessorNameString';
SQL Server Profiler Trace--Import multiple trace file in sql Table. --All the rollover files will be automatically imported --provide number tracefile to capture...
Find All Primary Key in SQL Serverselect schema_name(tab.schema_id) as [schema_name], pk.[name] as pk_name, substring(column_names, 1, len(column_names)-1) as [columns],...
SQL Server find Database User Permission--Execute the following script against the User Database where you need to find DB User permission. DECLARE @sql VARCHAR(2048) ,@sort INT...
Comments