Just Like That

This morning, one of the fellow developers shared the issue. He was getting the error below while opening any of the files: And some other guys came up with the same thing. I tried to find the root cause, was unable to do so. I'll update this post if I find that. However, there is good news. I've got the solution: Resolution steps are ; -Close Visual Studio - Go to the location C:\Users\ navdeep \AppData\Local\Microsoft\VisualStudio\11.0 (replace navdeep with your user id) - Delete the folder ComponentModelCache. - Start Visual Studio It builds the component cache and the things are working again  :-)

Hi All I just faced a problem with deleting the files. Shift + Delete was still using the recycle bin. However, the space available over the drive was 0 KB. Hence the deletion was not possible. Alternative way : Right Click on the Recycle Bin, and click on Properties: Use the second radio button for the drive intended. And we're good to go :)

Most often , when we leave the office, the things are working fine. However, we join in the morning only to discover certain things are not working. The build you deployed yesterday had all the things up and running. At times , the issue can be with the back end. Somebody modified a stored procedure last night, maybe. If you doubt such a scenario, query below might some in handy: use [name of the database] SELECT name, create_date, modify_date  FROM sys.objects WHERE type = 'P'  order by modify_date desc this will give you all those Stored Procedures that have been modified since creation.

Hi Everyone Today we'll be going through one of the issues I faced at my workplace. The issue was that records were being deleted from the DB table. Only service I knew was inserting records into the Table. Basically, in such scenario, we use the SQL Server Profiler. This is available in the Menu of Performance Tools under SQL Server 2012. Open the profiler: Click File >> New Trace. This will ask for the server against which you want to run the trace. Enter the Server Instance and the credentials. This will open up the Trace Properties Window. Use the Standard Template for the moment You can save the trace data to a file with a .trc extension. However, better approach can be saving to a database table. This all depends upon personal preference. Also, the trace can be time based. You can mention a time at which the trace ends. This is quite necessary as the trace can be quite resource consuming at times. Now, go to t...

Error: this template attempted to load component assembly 'NuGet.VisualStudio.Interop, Version=*, Culture=neutral, PublicKeyToken=*'. For more information on this problem and how to enable this template, please see documentation on Customizing Project Templates. I was getting this error in newly released and installed Visual Studio 2012 Ultimate on my system when I tried to create any Web Application. Possible Solution: i) Open Visual Studio > Tools > Extensions and Updates > select 'NuGet Package Manager' and uninstall it. ii)  Open Visual Studio > Tools > Extensions and Updates > select 'NuGet Package Manager' and install it. iii) And whoop, the error's gone

DECLARE @dbname sysname, @days int SET @dbname = null --substitute for whatever database name you want, null will fetch for all the databases SET @days = -n --substitute n with previous number of days, script will default to 30 SELECT  rsh.destination_database_name AS [Database],  rsh.user_name AS [Restored By],  CASE WHEN rsh.restore_type = 'D' THEN 'Database'   WHEN rsh.restore_type = 'F' THEN 'File'   WHEN rsh.restore_type = 'G' THEN 'Filegroup'   WHEN rsh.restore_type = 'I' THEN 'Differential'   WHEN rsh.restore_type = 'L' THEN 'Log'   WHEN rsh.restore_type = 'V' THEN 'Verifyonly'   WHEN rsh.restore_type = 'R' THEN 'Revert'   ELSE rsh.restore_type   END AS [Restore Type],  rsh.restore_date AS [Restore Started],  bmf.physical_device_name AS [Restored From],   rf.destination_phys_name AS [Restored To] FROM msdb.dbo.restorehistory rsh INNER JOIN ...