The first one is how the FK is currently defined. The nocheck there tells it to not check existing data.

The second statement enables the foreign key.

Does that help?

Gail -...

Please post all replies to the initial thread:

http://www.sqlservercentral.com/Forums/Topic1276016-1633-1.aspx

When you deploy your RDL, it imports the code into the database on SQL server.

You can extract the RDL from there (see this article: http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/ )

It is easiest to see...

Nice tool

Rod at work (3/30/2012)

---

SQLRNNR (3/30/2012)

---

Rod at work (3/30/2012)

---

Another question, which is related to this issue, concerns the different versions of SSRS. Our production database server is a SQL Server...

Great SNAKES!

The request was number...

PKI

This is not normal.

It sounds like there may have been an IO problem during the rebuild of an index that affected it.

Can you run that proc as that user from within a query window?

Unlike Tom, I am not a Confio Evangelist.:-D

My opinion on the tool - two thumbs up.

If you have the opportunity to use - take that advantage.

That user doesn't appear to have permissions on the proc being called from the job.

Rod at work (3/30/2012)

---

tom.wauters (3/30/2012)

---

You can access any database schema from within SSRS.

My first thoughts for your problem:

1. Make sure that the person who develops the report in SSRS is...

Rod at work (3/30/2012)

---

Another question, which is related to this issue, concerns the different versions of SSRS. Our production database server is a SQL Server 2005 Standard Edition. ...

Cost