thanks guys for the input.

I will try the switch later to see how it works for us.

Thanks Piers.  I am using SQL 2000 RS so the Iff(RowNumber) is not applicable, at least as you said so.  I will modify the stored procedure to remove the dynamic...

Thanks for the reply.  I forgot the IIF .  However the result set is a table come with a sort order input...

ouch

Thanks a lot!

thanks

Michael,

I am probably outdated.  Can you show me a link for this info?

Thanks a lot!

I don't remember the details but you can google for that.  I did google and found lot of problems reported.  We had some old DTS packages using ActiveX that SSIS couldn't...

it doesn't matter what you do with the schemas but I changed all back to DBO.  In case we let the developers go we don't need to worry about anything else...

is this time for new customers to pick Oracle instead of MS SQL?

Hint: do not use any wizard tool to upgrade or import/export from SQL2000 to SQL 2005. 

Here are what I did:

1. Use this KB to copy the logins to new...

I am glad you brought this up.  Another good feature removed from SQL2K.  Who did MS outsource the SQL2K5 to?

so we are going backward using command lines instead of GUI?  What a smart move by MS.

I almost gave up then I...

Jason,

That was what I did.  I opened the RDL in Notepad, changed from schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition to schemas.microsoft.com/sqlserver/reporting/2003/01/reportdefinition then uploaded the RDL using Report Manager.  What am I missing here?

Since you said you've...

Jason,

When I upload a report saved in VS 2005 to a SQL 2000 RS server, I got The report definition is not valid. Please verify that the report definition uses the...