Hi

try this .

Select *,Identity(1,1)NewID Into #Temp from YourTable .

Update YourTable Set TimeID=NewTimeId, StateID=NewStateID where NewID =YourCondition

Delete from YourTable

Insert Into YourTable

Select * From #Temp.

Hope this works.

If it doesn't can you...

hi

Are you trying to do it through the enterprise manager?. In that case the problem is that there are duplicate records.

Hope this helps you. 

Hi,

Hey you r forgetting one thing varchar can hold upto 8000 characters. In such a scenario comparing with REPLICATE('[0-Z]',Len(variable) will fail.

declare @var varchar(8000)

Declare @SpecialChar varchar(1)

Set @SpecialChar='!'

set @var = '1244'

Set @var=Replicate('Z',7999)+@SpecialChar

if ((@var...

Hi

We can get the dependencies from the execution plan. But this can be achived only with the help of a front end programming language like VB or anything or even...

Finaly I got it working after some 12 hours of research on all the various combinations of macros.

%ForEachEntity{%ForEachChildRel(){%ForEachFKAtt() {

ALTER TABLE %Child

ADD CONSTRAINT FK_%EntityName(%Child)$%AttName_%EntityName(%Parent)$%ParentAtt(%AttName) FOREIGN KEY(%ChildFK()) REFERENCES %Parent(%ParentAtt(%ColName))}

%DBMSDelim

}}.

Hi

Are you using "Select * from table" to open the recordset and then using

RecordSet.Fields(0),

RecordSet.Fields(1) to access the fields?

If not

How are you accessing the table?

Hi,

I want to automatically Name the Fk

as Fk_ChildTable$ChildColumn_ParentTable%ParentColumn

Thanx Allen

It really worked............

Hi

I think its mainly an access problem to the network resource. The user who is logged on to execute the job does not have access to the resource.

Try this round...

Hi

Run the DTS program, select the source Database and the destination database. Then select the tables that needs to be imported. After that click on the transform button aganist each...

U can use the DTS "Import Export Data from Start Menu" that comes along with the SQL server installation to Import the data from a text file into database.

Run...

Hi

I think that could be the reason. How can I know from the Server Settings if the installation is Case Sensitive?

Thankx Allen Thanx Kelley