Question on FOREIGN KEY CONSTRAINTS

I've recently implemented a whole bunch of foreign key constraints in a database. As a result I have issues every time I want to truncate a table to perform data loads.

Is there an easy way to tell the system to ignore these constraints for the term of a data load or truncation of data?

thank youwe had an entire thread (http://www.dbforums.com/t1100892.html) on that topic just the other day

check it out and let us know if you still have questions

Question on Action on SQL Server 2005 Analysis services OLAP Cubes in Excel 2007

Hi, all experts here,

I am having a question on actions implemented on SQL Server 2005 Analysis Services OLAP cubes, will SQL Server 2005 reporting services report action implemented on those cubes can also be available from Excel 2007?

Hope my question is clear for your advices and help and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

Hello Helen. Actions(SSRS2005 Actions and others) are supported in Excel 2007.

You can find out more about this in this document: http://www.microsoft.com/downloads/details.aspx?FamilyId=2D779CD5-EEB2-43E9-BDFA-641ED89EDB6C&displaylang=en

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot for your help. It's been very helpful.

With best regards,

Yours sincerely,