2005...

what commands did you use to move the system databases? also is it SQL 2000/2005/2008/2008R2

to add on from John's comment

or restore the db to a different name and use something like SQL Compare to see what the vendor has changed

Robin Sasson (5/21/2012)

---

k.subramanyam1017 (5/21/2012)

---

Hi friends,

could u please any one tell me the these questions

1) what is your company file architecture and how much data u r...

Care to share the solution incase someone else has the same issue?

anti virus blocking mass mail worms? or databasemail.exe?

firewall blocking port 25?

authentication issues?

SMTP server not set to allow you to send SMTP mail? (in exchange, you need to add the...

data types?

error messages?

what expressions have you tried so far?

Thanks Drew, learn something new every day.

No, as an index rebuild is a fully logged operation so it logs the same amount in Full or Bulk-Logged so there is no difference

Unsure if you will see the alter index, I would of said you would see restore database or restore log as its restoring the log, it just so happens that...

secondary server is generally in norecovery mode so no users, so no load on the database so can usually do things quicker as its not serving user requests

Yes, the index rebuild is logged to the transaction log and therefore replayed on the subsequent restore.

your using impersonation then, this is out of my skill set now, if the data source the report uses is set to use that particular SSRS_Virtual account then something is...

just so happens that in a previous role I was tasked with doing just that so I went for PS

This was my script (changed to prevent servername and databasename from...

data source been redeployed, check the data source is still set to use the SSRS_Virtual account