in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert statement the ident value would...

nice question to start on Monday with +1 :-):-P

good explanation

easy one

nice

BUt I told to not to change the stored procedure..

just need to pass the column value into variables of SP to insert rows one by one from employees

how to fetch one by one row using WHILE instead of cursor?

Hi Luis I added code of sthe stored procedure..

plzz find a solution for me

sp_helptext 'adduser'

CREATE PROCEDURE dbo.AddUser

@PortalID int,

@Username nvarchar(100),

@FirstName nvarchar(50),

@LastName nvarchar(50),...

thanks for the information Gila

ohhh....

Means if I delete any database then we cant restore it back anyhow?

Is there any way using logs file...

But I dont know that if the backup of that database is exist on sytem or not as I didnt take any backup of that...

thanks beeb...

I am able to migrate the data after deleting data through delete statement rather than using Truncate statement

thanks for the info Gila

Hi,

delete from Rolemaster is working and all data gets deleted

But I want that if I disable the constraint of the referencing table and then disable the constraint of RoleMaster then...