Looks like this is route we will take. We will upgrade all the instances and not have a mix of 2000 and 2005 as these are clustered instances. Applications that...

sp_sendmail is disabled by default.

Also I am not worried about the DTS packages / maintenance plans.

I am a little confused on the MSDB messages I got on the upgrade advisor.

I...

I am planning the same: backup old and restore to sql server 2005. My 2000 dbs have nothing fancy:

1. Regular maintenance plans: backup/Optimize/check integrity ...

2. Some instances have simple DTS...

I re-restored the db and it came up right away.

That works, thanks,

I am surprised that an alias was gone. Not sure how this got deleted.

thanks Lowell, I figured this out.

Coming back, the KB is confusing. It says use getUTFdate() in TSQL stmts  instead go getDate()  for dateDiff/dateAdd functions. But does not say the same while setting...

found it!. The apps had locked some tables and so the error!.

thanks

The SP will get fname+lname = user from a 3rd table...

got it! while creating sample data. There is no way that I can relate table1.field2 and table2.field4.

group1           fname lname

group1           fname2 lname2

group1           fname3 lname3

group1           fname4 lname4

group1           fname5 lname5

table2

field3           field4

group1             user1

group1             user2

group1            ...

In this case:

table1: -  field1, field2

table2: - field3, field4

field1=field2

so distinct/group by  of all the output:

field1, field2, field3, field4 is distinct as field2 and field4 have different values. ???

I get the same results:

with distinct or with group by or none of the 2: straight joins as I had in the begning.

Does not care with with either DISTINCT or Group by  ??

Did not think this will be so complicated

select t1.*, t2.*

from table1 t1

 inner join table2 on t2.field3 = t1.field1

where t1.field1 = 'char 200'            

I want field1, field3, field4 --?

When I use integrated security=SSPI, there is no need for uid/pwd. does this read my credentials ?

The following works in SQL QA:

select 

field1, field2.....

from OPENDATASOURCE(

 'SQLOLEDB',

 'Data Source=SERVER IP,PORT;Integrated Security=SSPI;'

&nbsp

I was in a similar sitituation. I first updated the column to a space and than alterted the table  to not allow nulls.

Depending upon number of records and data type,...