I am not understanding

Hello I have this code 
dateadd(day,max(fad)/1000, dateadd(year,floor(max(fad)/1000, '21-mar-1899')) as [DateP]
need to convert this to text format  as dd/mm/yyyy, now I get this value:2000-11-28 00:00:00.000

I don't know what is better to use virtual server or non virtual server, table of data 15 gb,trying to create tabular report by using power bi.

How can I fix it (RTRIM(pc.CODE))?

Msg 306, Level 16, State 2, Line 57

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Msg 4104, Level 16,...

Thank you

Yes it came back. Thank you

by putting these code:

WHERE (CONV_DATE > DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)) AND (CONV_DATE < DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 30))

I get error arifmetical overflow...

Can I use replication between sql server 2008 sp1 and sql server 20005 sp3 and sql server 2008 sp1 with sql server 2000

yes, but it is not working

SQL server 2008

I restored old distribution database from last week, where can I find out what I had before?

Is there way to see in distribution database?

Before I delete it,is there way to find out what was execly replicating from one db to another? thank you

I restored a back to a new database.

Had to delete publication for replication otherwise couldnt delete bad database, Of that database from local publication. SQL job that was sat up...