My new blog…
My new blog
Dear All,
Please visit my new blog, for the new posts please visit www.alokpandey.com.np
Second AspNetCommnunity Meet Up
Dear All,
We are pleased to announce that second AspNetCommunity meet up, where we will bring together IT professionals (.NET developers and others) & 3rd parties like business personnel who use .NET based products, for interaction and sharing innovative ideas to grow community. In this meet up we will not only be about sharing your ideas – we will also provide opportunities for you to interact with and have our questions answered by the very people who work on .NET technologies day-in
and day-out, and who can help us plan the features and architecture to support your business goals too.
Please make your valuable presence at the event and share your ideas with us. You can find the event details as under:
Date: 24th November, 2012
Day : Saturday
Time: 2 PM onwards
Venue: Community Hall – BrainDigit IT Solutions Pvt Ltd, Gyaneswor
AspNetCommunity members who have registered online will be sent invitation newsletters via emails. For more queries you can contact our community.
Please don’t forget to send us confirmation email if you are attending the event.
Contact Email: event@aspnetcommunity.org
AspxCommerce 1.1
AspxCommerce 1.1
AspxCommerce is an Asp.Net based complete open source e-Commerce solution built on top of SageFrame, which enables you to maximize the success of your online business. AspxCommerce is a complete package for both new or existing merchants who need to design, configure, customize, manage and open their online storefronts.
For new features just Click On
To Download Just Click On
For New Free Templates
http://fashionhouse.aspxcommerce.com/
http://electronics.aspxcommerce.com/
http://flowershop.aspxcommerce.com/
http://jewellerystore.aspxcommerce.com/
http://mobilestore.aspxcommerce.com/
Get Started SageFrame
On using SageFrame for your web development, you can, not only gain benefits of a CMS that is easy to use, but also an ability to create your own custom applications. Similarly, you can use applications and modules developed by other users. SageFrame’s plug and play modular architecture enables you to plug a desired module into your system and acquire the required feature instantly.
Explore awesome features with SageFrame 2.0
SageFrame strives to give you the best CMS experience in the web. We hope you had an awesome experience with SageFrame 1.0, but with SageFrame 2.0 we promise you even more – enhanced features, flexibility, ease of use and lots more. SageFrame 2.0 is stunningly awesome – explore more.
Features
• Easy single click installation
• Dynamic content management
• Robust site security
• Plug and play modules
• Inline editing support
• Inbuilt module packaging and publishing support
• Localization Support
• Multi-portal Support
SageFrame 2.0 available to use
http://sageframe.com/
For demo just visit
http://demo.sageframe.com/
For Downloads
http://sageframe.codeplex.com/
How to choose and set up payment options in AspxCommerce
How to choose and set up payment options in AspxCommerce .Net eCommerce software
Difference between Function (UDF) and Stored Procedure on MSSQL
Difference between Function (UDF) and Stored Procedure on MSSQL
Functions
1- Can be used with Select statement
2- Not returning output parameter but returns Table variables
3- You can join UDF
4- Can not be used to change server configuration
5- Can not be used with XML FOR clause
6- Can not have transaction within function
7- Can be used in Select list
8- Versioning (grouped) Not Allowed
9- Schema Binding Allowed
10- GETDATE() or other non-deterministic functions Not Allowed
11- SET OPTION Allowed
12- Temp Object Not supported
Stored Procedure
1- Have to use EXEC or EXECUTE
2- Return output parameter
3- Can create table but won’t return Table Variables but possible in MSSQL 2008/2008 R2
4- You can not join SP
5- Can be used to change server configuration
6- Can be used with XML FOR Clause
7- Can have transaction within SP
8- You can not use in SELECT list
9- Compiled, can remember execution plan
10- Schema Binding Not Allowed
11- GETDATE() or other non-deterministic functions Allowed
12- SET OPTION Not Allowed
13- Temp Object Accessible – You can use the temp tables inside the procedure
Reference
How to drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement on MSSQL 2005/2008/2008 R2
How to drop all the tables, stored procedures, triggers, constriants and all the dependencies in one sql statement on MSSQL 2005/2008/2008 R2
Script
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND category = 0 ORDER BY [name])
WHILE @name is not null
BEGIN
SELECT @SQL = ‘DROP PROCEDURE [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped Procedure: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘P’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all views */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘V’ AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP VIEW [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped View: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘V’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all functions */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’) AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP FUNCTION [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped Function: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] IN (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’) AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
/* Drop all Foreign Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ ORDER BY TABLE_NAME)
WHILE @name is not null
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint IS NOT NULL
BEGIN
SELECT @SQL = ‘ALTER TABLE [dbo].[‘ + RTRIM(@name) +’] DROP CONSTRAINT [‘ + RTRIM(@constraint) +’]’
EXEC (@SQL)
PRINT ‘Dropped FK Constraint: ‘ + @constraint + ‘ on ‘ + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘FOREIGN KEY’ ORDER BY TABLE_NAME)
END
GO
/* Drop all Primary Key constraints */
DECLARE @name VARCHAR(128)
DECLARE @constraint VARCHAR(254)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ ORDER BY TABLE_NAME)
WHILE @name IS NOT NULL
BEGIN
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
WHILE @constraint is not null
BEGIN
SELECT @SQL = ‘ALTER TABLE [dbo].[‘ + RTRIM(@name) +’] DROP CONSTRAINT [‘ + RTRIM(@constraint)+’]’
EXEC (@SQL)
PRINT ‘Dropped PK Constraint: ‘ + @constraint + ‘ on ‘ + @name
SELECT @constraint = (SELECT TOP 1 CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ AND CONSTRAINT_NAME <> @constraint AND TABLE_NAME = @name ORDER BY CONSTRAINT_NAME)
END
SELECT @name = (SELECT TOP 1 TABLE_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE constraint_catalog=DB_NAME() AND CONSTRAINT_TYPE = ‘PRIMARY KEY’ ORDER BY TABLE_NAME)
END
GO
/* Drop all tables */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘U’ AND category = 0 ORDER BY [name])
WHILE @name IS NOT NULL
BEGIN
SELECT @SQL = ‘DROP TABLE [dbo].[‘ + RTRIM(@name) +’]’
EXEC (@SQL)
PRINT ‘Dropped Table: ‘ + @name
SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = ‘U’ AND category = 0 AND [name] > @name ORDER BY [name])
END
GO
Reference
The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’ on IIS 7.0/7.5
The login failed. Login failed for user ‘IIS APPPOOL\DefaultAppPool’ on IIS 7.0/7.5
You are trying to jump start an existing ASP.NET site on a new IIS 7.5 server under Windows 7/7.5 or under Windows 2008 R2, and you are getting this error message: The problem is in IIS 7.5 DefaultAppPool settings.
Windows 2008 Server with IIS 7.0/7.5 runs DefaultAppPool using Network Service user:
Windows 7.0/7.5 and Windows 2008 Server R2 with IIS 7.5 run the same pool under a different user – ApplicationPoolIdentity:
All you need to do is to change that setting on your machine.
Use IIS Admin – Application Pools.
1- Right mouse click on DefaultAppPool row,
2- Select Advanced Settings,
3- A first setting under Process Model group is Identity,
4- Select it and using a drop down list change Built-in account from ApplicationPoolIdentity to NetworkService.
Now check your application log in, it will work
Hope this will work
Er. alokpandey's Blog 
leave a comment