There's a lot of stuff that worked on 2000 that won't work (or works differently) on 2005.

Gila,

Can you please list out those which does work in 2000 and 2005??????

...

Hi Barry,

I did'nt understand the second method you were mentioning i.e. using a View.

Can you give me an example of how it is going to be implemented????

Thank you.

Hi,

Would like to know, how much impact will be there in the front end changes if i have migrated from sql 2000 to 2008.

For example) Connection String , dts to...

Hi,

Would like to know, how much impact will be there in the front end changes if i have migrated from sql 2000 to 2008.

For example) Connection String , dts to...

All the backups are from SQL Server 2000 Standard with SP3!

If that is the case, tell me whether following thing works for side - by - side upgade?

1.Install SQL 2008 with SP1

2.Restore or overwrite the system databases. i.e. master,msdb.

3.restore all...

Okay.

If i want to implement the same logic, can we do it in any other alternate way?

Okay.

If i want to implement the same logic, can we do it in any other alternate way.

Thanks Gila! That was really good.

Any work aroud for the above requirement, if i have to do so?

Thanks Gila!

What is the difference between xp_sendmail and sp_send_dbmail?

Yeah! True i agree to the point you have mentioned.

Thank you.

I managed to fix this.

select a.slno,a.c1,a.c2,a.flag,

(select count(case when b.slno = 1 and b.c1-b.c2 = 0 then null -- for the first record if c1-c2 = 0

...

Hi, small change. I would like to have one more column say “flag”. So whenever there is a change in the flag value, the C3 column value has to start...

Sweet! 🙂

Thank You.