If you are getting the “Error 310 (net::ERR_TOO_MANY_REDIRECTS):” in Chrome, ensure you still have a default document defined in IIS that is reachable. I had accidentally removed my web.config file on my workstation and, since I don’t use the default Coldfusion document of ‘index.cfm’, my redirect from ‘index.cfm’ to my default document (actually called ‘default.cfm’) was causing an infinite loop that Chrome was smart enough to give up on. IE just locked.
Show line numbers in CFEclipse (IBM RAD, Eclipse)
To turn on line numbers for code viewing: Windows —> Preferences .
Use the search box and type in ‘number’
IIS error “The system cannot find the path specified.” after CF removal
I was taking down a site permantently and just wanting to add a ‘retire’ message when, after using the ‘CF web server configuration tool’ to remove the CF mappings on the site, I was getting the error: “The system cannot find the path specified.”
I thought the tool would remove the mappings for CFM, CFML, CFC, etc but it didn’t. I had to use web site properties > home directory > configuration to remove both the extensions and maps. maybe restarting the server would have cleared them out but this worked without a restart.
Excel not opening files
About a month ago, Excel has had trouble opening native files. I could double click an XLSX file and Excel would start only to tell me the file I was trying to open (and just used to launch Excel with) didn’t exists.
The following (in a cmd window) seems to have fixed it:
"C:\Program Files\Microsoft Office\Office\Excel.exe" /Regserver
How to determine the current database context in SQL Server
I like to run a check script I’ve crafted that tells me stats on the database before I upgrade and perform schema changes. To make the script more universal, I wanted it to report the name of the database the stats are for (for printing purposes). I knew how to check the database server hostname (IF @@SERVERNAME = ‘[expected hostname]‘ … ) but I couldn’t find how to check the database context on that server.
I found my answer: db_name()
Now I can check server name and database context before running code changes:
IF db_name() != N’[database]‘ BEGIN …
How to change the path/move a project in Visual Studio
- Set the property ‘File Path’ to the new location.
- Reload the project.
- In case you didn’t rename the project, rename it (F2).
Taken from here: http://stackoverflow.com/questions/211241/how-do-i-rename-a-project-folder-from-within-visual-studio
SSRS: Could not load type ‘Microsoft.ReportingServices.UI.GlobalApp’
I suspect some MS patch caused this as no one has touched this server in months yet today, we got the following:
Server Error in ‘/Reports’ Application.
Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.
Parser Error Message: Could not load type ‘Microsoft.ReportingServices.UI.GlobalApp’.
Source Error:
Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="Microsoft.ReportingServices.UI.GlobalApp" %>
|
Source File: d:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\global.asax Line: 1
Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407
The solution is presented in the error message. Notice the bottom line in the error message: ‘Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407 ‘ – This should be running .NET 2 so we change the mapping for the applicaiton, /Reports and /ReportServer virtual folders to use V2 of .NET again (right click > properties > ASP.NET tab).
Database diagrams on disconnected devices
If you try to use the database diagram feature in SQL Server Management Studio and the owner of the database is a domain id but you are disconnected from the domain (notebook users!), you’ll get an error like this:
“Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.“
What you need to do is change ownership of the database:
/* replace the database name parameters with [CTRL]+[SHIFT]+[M] */
use master
go
ALTER AUTHORIZATION ON DATABASE::<Database_Name, sysname, Database_Name> TO “sa”
go
use <Database_Name, sysname, Database_Name>
go
EXECUTE AS USER = N’dbo’ REVERT
go
Securing a single file with IIS7
With IIS7's revamped interface, I had a hard time locating how to change the permission on a single file. I could see how to do so at a folder level, but I couldn't see how to do so on a single file (.CFM in this case).
It turns out, once you hilghted the file you want to change the permission on, you right click and select 'Switch to Features View' – this changes to the features view on that one, single file. Then you can use the Authentication module to set it up the way you want. You can tell you are changing one file by looking at the breadcrum trail in your address bar.
8.3 Short filenames on Windows 2003 Server
If you have a document repository of sorts, it may pay to disable short filenames (legacy leftover from Win95 days).
To check if enabled:
fsutil.exe behavior query disable8dot3
To disable:
fsutil.exe behavior set disable8dot3 1
This will not remove existing short filenames but the system will no longer generate them. This also works on XP.


