Category: Uncategorized
-
Remove Empty Directories using c#
private static void DeleteEmptyDirectory(string startLocation) { foreach (var directory in Directory.GetDirectories(startLocation)) { DeleteEmptyDirectory(directory); if (Directory.GetFiles(directory).Length == 0 && Directory.GetDirectories(directory).Length == 0) { Directory.Delete(directory, false); } } }
-
How to ALTER all tables columns in SQL Database
-
Exception- The definition for user-defined data type ‘MyTypeList’ has changed.
The definition for user-defined data type ‘MyTypeList’ has changed. Exception when we rename or changed any User defined TYPE and it used in stored procedures. Stored Procedures which is using this type variable will not run and throwing the exception. If we have large numbers of SP then it will to time consuming or irritating…
-
How to check SQL Job is in running state?
Method 1: System Stored procedure: sp_help_job, returns information on the job, its steps, and more. EXEC msdb.dbo.sp_help_job @Job_name = ‘Your Job Name’ Method 2: IF EXISTS(SELECT 1 FROM msdb.dbo.sysjobs J JOIN msdb.dbo.sysjobactivity A ON A.job_id=J.job_id WHERE J.name=N’Your Job Name’ AND A.run_requested_date IS NOT NULL AND A.stop_execution_date IS NULL ) PRINT ‘The job is running!’ ELSE…
-
Cannot load Counter Name data because an invalid index ” was read from the registry
Cannot load Counter Name data because an invalid index ” was read from the registry When we are trying to read system performance counters, some time we will get this type of error on machines. “Cannot load Counter Name data because an invalid index ” was read from the registry” To fix the issue: Click…
-
Java.IO.IOException: ‘Cleartext HTTP traffic to xxx.xxx.xxx.xxx not permitted’
Goto Android Project, then click on properties, Click on AssemblyInfo.csAdd: [assembly: Application(UsesCleartextTraffic =true)]
-
Fix: SQL Server Management Studio 18.0 won’t open – only splash screen
Replace the “Microsoft.VisualStudio.Shell.Interop.8.0.dll” in “C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PublicAssemblies” with the copy from “C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PrivateAssemblies\Interop” and then try. It should work.
-
CSS Framework: Zurb Foundation vs. Twitter Bootstrap
In the vast world of rapid prototyping CSS frameworks and toolkits, there are a ton of different options to choose from. For those of you who don
-
How to find column in Database
Select * From INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like ‘%Phone%’