I'm having the exact same issue if I enter the IP Address instead of server name it works. Looking forward to see if somebody posts a solution.

Thanks for the reply. We have a project in the works to upgrade this database to SQL 2008 but for now we are stuck with SQL 2000 🙁

If...

Thanks for the reply. The query works but it is taking about 30 minutes for 8987 rows. Another issue is I'm trying to create a view out...

post edited this is in SQL Server 2000 so this does not work

SELECT

ROW_NUMBER() OVER (ORDER BY Score DESC) AS Rank, Bridge_ID, Score

FROM BRIDGE_SCORE

ORDER BY Score DESC

How would you add the subject to the message instead of getting the default of "SQL SERVER MESSAGE"?  I've tried adding the @subject = 'Test Subject' but get an error...

I've moved it using the method you described, I also tried using DTSBackup2000

The folks on our database team know that SAN is the better choice and we've tried to express that to management but without some hard evidence we are fighting a losing battle. ...

Using the CD, I successfully upgraded from Standard Edition to Enterprise Edition.  Thanks for the replys.

Try http://www.extremelogic.com They are in Atlanta, GA. I've had good trainging experience with them.