How about some sample data. Please see my first link in the signature below.

check for Row_number() in BOL.

This should work:

SELECT convert(varchar,dateadd(m, 1, getdate()),103) + ' ' + convert(varchar,dateadd(m, 1, getdate()),114)

Please ensure that you are using .BAK or .TRN for the extension instead of just BAK or TRN.

Grant VIEW DEFINITION on the procedures.

Please post some sample data with create and insert statements.. Please look at my first link on the signature.

See if this help:

http://support.microsoft.com/kb/328306

How are you connecting. Windows or SQL authentication.. Does the user have relevant permissions?

You can do something like this:

select so.name as tablename,si.name as indexname from sys.indexes si

inner join...

What port is 2005 instance running on.

By default 2000 uses 1433. Make sure they are different. You can't have the same port.

Could you please confirm the following:

1. SQL Browser service is running on the server.

2. On the firewall put the exception for sqlbrowser.exe and/or UDP port 1433.

3. Can you get to...

When you go SQL Server properties; is there a tick against Allow other SQL Servers to connect remotely to this SQL Server using RPC.

This should work:

select * from sys.database_principals

Have you tried the 'Case Statements'.

Personally i would use the DATE function which is a new thing in SQL 2008 and is much easier. If i was using 2005 then i would use convert.