Within Enterprise Manager, you can right click on the database and choose All Tasks -->Generate SQL Scripts... On the options tab you can choose whether you want primary keys, foreign...

select c1, count(*)

from table

group by c1

having count(*) > 1

If this is on the wrong track, explain the 'before data rows:' and 'after data rows' part.

Any chance you could use SQL to make a backup of the db on SQL7, then copy the file to the SQL2k server and do a restore?

Otherwise, you might try...

Could you add an identity field to your table that increments as records are inserted and use it in your order by clause?

That is it!

Thanks,

Michelle

I have 4 SQL Servers running on Quad Xeon processors with hyperthreading enabled. In the past I have had one system shutdown (found out it was bad install of...

Do you have an identity field or can you alter the structure to add one? Then you could always query the max(iden_field) when you needed the last record that...

Thanks All!

I too have used Excel and Access when I can't think how to do it in SQL, but wanted to know how it could be done. I appreciate...

create table admin.dbo.temptable

(textdatetime char(16))

insert into admin.dbo.temptable

values('010203 12:00')

alter table admin.dbo.temptable

add field2 datetime

update admin.dbo.temptable

set field2 = textdatetime

where isdate(textdatetime) = 1

select * from admin.dbo.temptable

textdatetime

010203 12:00 ...

select * into newtable

where isdate(hopefully_date_field) = 1

Insert into newtable

select field1, case field2

when isdate(hopefully_date_field) = 1 THEN hopefully_date_field

else null

end

Either of these help?

Sorry about that. Does this help?

"Unless the text in row option is specified, text, ntext, or image strings are large character or binary strings (up to 2 gigabytes) stored...

Go look at Books Online in the Transact-SQL Reference section and look at the article 'char and varchar'

Michelle

They should work normally as long as you don't change datatypes, fieldnames or tablenames when you upsize to SQL. What is prompting your move?

If you are only going to...

HTH = Hope This Helps

Obviously it didn't.

Is the group a local group to that machine or a global group on the NT domain?

Make sure you do not have bigint as a datatype in any of your SQL tables.

Make sure your decimal datatypes aren't bigger than (15,4).

Make sure none...