So you dont know the name of at least 1 table within the database without looking at it in object explorer?

Do you not have a DEV/TEST/UAT copy of the database...

No, your using the wrong date function, your adding to a date instead of getting the part of the date you want.

The clues are in the bold italic text of...

Did you google "DATE functions in T-SQL"

If so the first link would take you through all the different date functions that exist in SQL and you would of found the...

Please answer the question I have asked twice.

Can you query the tables or not or have the tables been dropped from the database?

If not you will need to...

sp_help by default unless you have changed it.

Can check by the following menu items.

Tools --> Options --> Environment --> Keyboard

As long as DNS can resolve between the two domains, then you should be fine. As your using IP it should just be a simple connection string change, if...

A logon trigger or a trace for audit login which logs to a trace file or a trace table which you can then query to see who logs into the...

Sorry, my bad, been a couple of years since worked with file share subscriptions.

Yes the username and password is stored within the subscriptions table in the executionsettings column, but they...

Looks like replication didnt cleanly remove all articles from the publication.

I would look through and follow this link http://support.microsoft.com/kb/324401

missing how, just missing in object explorer or can you not even select from them in a query window?

Google "DATE functions in T-SQL"

You dont need IIS for SSRS from SQL 2008 onwards.

Configure the new Reporting Services instance [AX 2012]

Can you do a select from a table you know in the database as a query or have the tables been dropped from the database?

If so do you have backups?

Have you tried to remove the table from the publication?

Google DATEADD

DATEADD(YEAR,-1,GETDATE())

Also dont use string litterals for dates, use the an ISO date format like YYYY-MM-DDTHH:MM:SS.ms