Everything Windows – Windows Server – SQL Server – Windows 10, 8, 7, even XP
MS Office tricks – Registry secrets – Applications – Browsers
This problem occurs, when you have a column with a formula that sometimes returns an error. That is very typical for all kind of look-up situations . Let’s say, you have a column E with formula that returns good values and errors. You need to count how many errors are […]
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 […]
Summary First of all – it is not a virus! It is not a bug either. It is a feature, that doesn’t allow legacy applications to write files inside Program Files directory. This feature allows legacy applications think that they are writing to a system folders. Symptoms You can see […]
After several days of heavy exhausting battles and sleepless nights, after testing dozens of options, after browsing many proposed Internet solutions, I finally was able to move an old instance of Windows XP on a new machine with new RAID drivers. That happened at 13:23 on December 12, 2010. I […]
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 […]
SQL Server 2008 allows to store binary data, if Database has a FILESTREAM feature […]
This fix was tested with Windows XP Pro SP3 with Office 2003 SP3 and McAfee AntiVirus Plus. Finally. Finally I found a solution for this really scary-looking error message that was bugging me since 12/24. Marry Christmas! Description of a Problem Every time you restart you PC you see a […]
Sometimes you need to display or print a SQL table structure. This article provides a SQL statement that allows you to do that. We are using MS SQL 2008 Studio interface. […]
There are two ways to reset forgotten Administrator password. Method one – Reset During Repair Reinstall: Use Win XP installation disk Run Recovery (not Recovery Console) Press Shift+F10 during GIU portion of repair / install Run LUSRMGR.MSC to reset any user password to whatever you want During my tests, this […]
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 […]
© 2017 DomainWebCenter.com. All Rights Reserved. | Disclaimer | Contact the Editor