Skip to main content

Posts

validate email and phone number with Regular Expressions

Here is sample to validate Phone, Email, URL http://www.costudio.com/contactus.asp emailRe = /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*\.(\w{2} (comnetorgeduintmilgovarpabizaeronamecoopinfopromuseum))$/ phoneRe = /^((\+\d{1,3}(- )?\(?\d\)?(- )?\d{1,5})(\(?\d{2,6}\)?))(- )?(\d{3,4}) (-)?(\d{4})(( x ext)\d{1,5}){0,1}$/ http://javascript.about.com/library/blre.htm Jquery Validation http://bassistance.de/jquery-plugins/jquery-plugin-validation/
Read more

install sql server express 2005 to Vista 64

IIS on a 64 bit system runs by default the 64 bit version of the framework and SQL Server express is a 32 bit application so that is what is causing your problem since it needs the 32 bit framework to operate correctly. There are 2 solutions: 1. Install SQL Server 2005 x64 developer edition instead of the express edition. This version however is not free so you will need to purchase a license witch luckily for us is not as expensive as a standard or enterprise license. Or: 2. Click start > run and type: (maybe need make start.bat, and right click to run as administrator) cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 That will force your IIS to run in 32 bit emulated mode. then again at run or a command prompt type: %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i To register the 32 bit framework with IIS. After that you should be able to install the larger version (x64) capable of SQL Server Express 2005 without...
Read more

Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005

Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005: "Subsystem % could not be loaded" "The Snapshot subsystem failed to load" SYMPTOMS loadTOCNode(1, 'symptoms'); Consider the following scenario. You perform one of the following actions in Microsoft SQL Server 2005: • You restore an msdb backup. • You attach an msdb database. • You change the information in the syssubsystems table in the msdb database. Solution: 1. In SQL Server Management Studio, run the following script.use msdb go delete from msdb.dbo.syssubsystems exec msdb.dbo.sp_verify_subsystems 1 go 2. Stop and then restart the SQL Server Agent service.
Read more

How to: Replicate Schema Changes - Alter Replicated tables

By default, the following schema changes made at a Publisher running SQL Server are replicated to all SQL Server Subscribers: ALTER TABLE ALTER VIEW ALTER PROCEDURE ALTER FUNCTION ALTER TRIGGER If you do not want to replicate schema changes for a publication, disable the replication of schema changes in the Publication Properties - dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio) . To disable replication of schema changes On the Subscription Options page of the Publication Properties - dialog box, set the value of the Replicate schema changes property to False. Click OK. To propagate only specific schema changes, set the property to True before a schema change, and then set it to False after the change is made. Conversely, to propagate most schema changes, but not a given change, set the property to False before the schema change, and then set it to True after the change is ...
Read more

change Login to a user in sql server

Add the new login. USE master go EXEC sp_addlogin 'NewMary' go --Change the user account to link with the 'NewMary' login. USE pubs go EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary' EXEC sp_change_users_login 'Update_One', 'ESPDAUser', 'ESPDAUser'
Read more

js not working in firefox

in IE, document.all is working but not in firefox, in firefox have to use document.getElementById instead IE: document.all.tab1Div.style.display='none'; document.all.tab2Div.style.display=''; document.all.tab3Div.style.display='none'; document.all.li1Div.className = ''; document.all.li2Div.className = "selected"; document.all.li3Div.className = ''; Firefox: document.getElementById('tab1Div').style.display='none'; document.getElementById('tab2Div').style.display=''; document.getElementById('tab3Div').style.display='none'; document.getElementById('li1Div').className = ""; document.getElementById('li2Div').className = 'selected'; document.getElementById('li3Div').className = '';
Read more