SQL server -T-SQL questions and examples.
Lessons once learned and now recorded.
What is Wrong with Home Server? After a RAID drive hiccup on my local Windows 2008 Server, I was more inclined to consider an external hosting options. And one of my friends already uses Amazon hosting for at least 4 years now. So I decided to invest some time to […]
After synchronizing your laptop with corporate policies you might notice that multiple black command windows will popup on a regular basis that might even look like some virus. You are in luck if you hade ADMIN rights on your laptop. You can easily go to registry and delete all references […]
This article describes, how to automate database backup in SQL Express with mixed Windows and SQL Authentication running on Windows 2008 Server. This material was tested with Microsoft SQL Server 2008 R2 Express. SQL Server 2008 Enterprise comes with Maintenance Plan feature. That feature allows amazing flexibility and auditing. SQL […]
You have a large table (in my case it has 8,697,647 records) with an Asset Number and a Business Unit, and you would like to know if any asset has record with multiple Business Units. You can count records of unique Asset/BU combinations, but this is not what you want: […]
Here is a problem resolved here – you can connect to MS SQL Server 2012 from the office, but when your try to connect from home over remote (in this case AVENTAIL) connection you would get an error message: “Cannot generate SSPI context“. Once again, from the office you can […]
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 […]
Scenario Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field. This should be a numeric field indicating the sequence in […]
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’. […]
If you connecting to a table using subquery, you might experience an error “Subquery returned more than 1 value“, that will crash your SQL. Here is an elegant and powerful solution that (1) cures the error and (2) allows to locate your desired row more precisely. For example, you […]
ASP.NET page returns this erorr: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’. (1) First try running this command/wizard: %WinDir%\Microsoft.NET\Framework\v2.0.50727\aspnet_regsql.exe (2) If this doesn’t work, try this query: — Add user ASPNET to DB role USE YourDB GO sp_addrolemember ‘aspnet_Membership_FullAccess’, ‘ASPNET’ These steps should resolve your […]
You are trying to access your ASP.NET page and getting this message: Cannot open database “YourDB” requested by the login. The login failed. Login failed for user ‘YourPC\ASPNET’. Use SQL Manager, navigate to Security ==> Logins. Double click on ASPNET user and go to User Mapping. Select YourDB and […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor