Julian date is stored in YYYDDD format, for example 12/31/99 will be stored as 99365 and 01/01/2017 will be stored as 117001. If you need to convert the date from YYYDDD to any conventional date format like dd/mm/yyyy in SQL use steps below. The idea is to convert year and […]
Environment ASP or ASP.NET site is running on IIS 7.5. SQL Server 2008 R2 Express (10.50.1600.1) running on Windows 2008 Server R2 (W2K8 R2) x64. Problem You will see one of two errors depending on whether you dealing with ASP or ASP.NET sites. On ASP.NET sites you will […]
Task You already have a working WordPress (WP) site. Now, you need to add one more site with a new MySQL database. This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip […]
Cannot open database “Your_DB” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITYNETWORK SERVICE’.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database “Your_DB” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITYNETWORK SERVICE’. […]
This article shows how to use string parameters to make selection on Boolean fields. What is it you need to select “true”, “false” of “ALL” records. How WHERE statement will look like in that case? […]
This article is about moving your Windows-based WordPress and other sites (some ASP, some ASP.NET) from older to a newer instance using AMAZON cloud server instances. Procedures described here do not involve any installation. Just copy files and edit CONFIG files. We do not manipulate Registry as well (except to change […]
This article contains 3 examples: – T-SQL; – MS Access; – AS/400. This example shows a standard T-SQL syntax tested on MS SQL 2005 server: update P set P.CertMemberLevelID = Z.CertLevelTo from UPM_MemberPermissionMask P INNER JOIN zzzCertRegistryUpdate Z ON P.MemberID = Z. Cert2ID Here we are updating one […]
It was time to move many sites from W2K3 Server (Windows 2003 Server) and SQL 2000 Server to a new W2K8 Server (Windows 2008 Server) and SQL 2008 Server. And if I ever have to do it again, I will check with these notes. The greatest secret in technical life […]
You have 180 days to evaluate. You can check number of days till expiration: open your SQL Server Management Studio and widen first line in Help — About box. What if your trial is about to expire, and you need just a few more days to evaluate? You can switch […]