hi folks, Iam working sql server 2005 Iam unable to change the already existing identity value. Pls think a while for this,,,,,,i already tried alter table "ALTER TABLE ALTER COLUMN IDENTITY (x,y)" its urgent thanks in advance

Rupa

I need to know the tables which are in related with the same foreign key. Pls do tell the table which constitutes the FK available in the database. Means that IS there any table in the database in SQL SERVER which is having the FK's.sitting in it. Please try to understand the query first,then reply it in more meaning manner

Surya

ORA-12154 TNS:could not resolve service name Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file. Action: Make the following checks and correct the error: Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location. Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary. Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the Oracle Net Services Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager.

Rupa

Hi everbody, Iam currently working on datbase design. Iam stucked at:If a primary key is assigned in database,I need to know all the foreign key relation of this PK on other tables in that database. please help out on this, thanks in advance, Rupa

Rupa