If u Truncate the log file using TRUNCATE ONLY(by either shriinking log or by either taking backup)

OR

Switching to simple recovery model

OR if u miss one of the log file between...

I dont remember the whole path of the file, if u have a dump of SQL.

But u can do search on that folder for file, setup.exe

(I think u can...

can u just copy paste the error message u r getting while execting above?

Do u have your SQL 2005 C.D with you which u had initially used to install SQL server on your machine?

nice

which utility did u download. If its Tablediff, it comes with SQL installation and usually installed here:

"C:\Program Files\Microsoft SQL Server\90\COM\TableDiff.exe"

http://weblogs.sqlteam.com/mladenp/archive/2007/03/03/60125.aspx

Do a search on TableDiff utility in google.

Other issues that I can think of between servers transfer is,

1)N/W bottleneck: Do you see ASYNC_NETWORK_IO when transfer is between servers when u use sysprocesses.

2)constraints enabled in destination server...

Whats so urgent, did u or some maintenance job run CHECKDB and got info message from SQL to run those commands?

I am just adding myself so Iam in the loop to for this problem

Introducing Primary Key is enforcing business rules concept.(its more logical concept)

Enforcing Clustered indexes is in regard to your maintenance of your table(Searches, Sorting of ur table, more physical concept)

To get previous tables Identity, u can use SELECT @@IDENTITY

so if u have

INSERT INTO TableA(ColA,ColB)

VALUES(@ColA,@ColB)

where ColA is not ur Identity column as Identity key gets self generated.

SELECT @TabBColA =...

Primary key enforces uniqueness and also doesnt allows NULL.

I would agree with you. I dont think its possible to Restore a 2008 database to 2000

What query do you have? Tend line of some numbers would be to determine how your numbers are going, if they R tending up or they are tending down. A...