Thanks for the reply...maybe some more information about what we are looking for will help. The Foreign keys are the issue. We have found that a bulk insert on a...

Got it ...thanks....but I am still confused as to why the serverproperty is coming back disabled when the Control panel tells a different story! But does not matter really .......

What does disabled indicate? I know we installed one server with processor 2 because that is the license we had but the serverproperty indicated that it was disabled. We are...

Figured it out.....does not work on version 7 SQL Server but does work on SQL 2000.

THANKS!

Tried this ....

select serverproperty('LicenseType')

and get the following message.....

Server: Msg 195, Level 15, State 10, Line 1

'serverproperty' is not a recognized function name.

Am I missing something?

THANK YOU....I actually am the DBA but have not had any hands on the Analysis Services and I welcome any information. Thanks again.

BABs

Thanks Brian!

Bettyann Bowes