No Picture
ASP.NET

The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’

ASP.NET page returns this erorr: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘YourDB’, schema ‘dbo’. (1) First try runing 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 […]

No Picture
SQL Server

Update Field Based on a Field in Another Table

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 […]

SQL Server

How to Re-Install SQL Server 2008 Evaluation

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 […]