but i need when i insert data through form like name address, cell number , the customer id will increase automatically which is not happen at this time..... any idea?;-)

Thanks dear.... its working now:-)

i have create the table structure as......

use MMS

create table customer(

id int not null,

fname varchar(50),

lname varchar(50),

cust_add varchar (250),

comments varchar (250),

); id DBCC CHECKIDENT

and i got the error like....."Msg 102, Level...

Setting in memory are looking good...... the problem is some where else.... becuase on my sql server there are same settings......

Can send the problem error in detail so that i...

Any application which were accessed through web is need secure enivonment. It s important when so many user access application thoguh web.

It is better to organise user in agrups...

There are more then 25 tables in Monrtgomery Database . I have login in system as Administrator on both system and start SQL Server . Then i connect to Both...

You know that Sum() is taking input as Quantity so anything you need to update Sum means you need to change in quantity. If you need to process on output...

update product set[quantity]='25' where p_id='1' and [supplier name]='aa'

i hope you need this query.....:-)

update product set[quantity]='500' where p_id='1' // this is the case when you have recods in one table that is procuct. so when you change the quantity then your...

Hello,

You need to create the table

USE [database name]

GO

/****** Object: Table [dbo].[product] Script Date: 04/20/2009 21:50:11 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[product](

[p_id] [nchar](10) NOT NULL,

[name]...

Hi,

It seems that you have properly creating a job for Agent...

You need to follow the step again then might it works.

Execute sp_add_job to create a job.

Execute sp_add_jobstep to create...

Hello,

My problem is that i am not able to start MSSQLSERVER, when i start MMSINDIA server group, right click on it and select start..... on a bottom it displayed a...

Hello Kelly,

How are you???

First things is correct. when we attept to start SQLSERVER, it shows the message in Log file as like......

"2007-10-27 03:32:50.62 server SQL Server...

Hello

When i start one of Sql Server Group, it shows a message SQL Server not exist or Aceess Denied.

Could not start the MSSQLSERVER service on Local Computer.

The service did...