Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

1.7k questions

3.2k answers

401 users

Categories

1.7k questions

3.2k answers

401 users

Hello all and thank you for reading my post.
I was wondering if anyone has created a global change that updates or references tables in the Data Warehouse.

Here is a snippet of code I've been working on.

DECLARE  @RPTDWDB        VARCHAR(100)
        ,@SQLStatement  NVARCHAR(4000)

SET @RPTDWDB = 'My_RPT_BBDW'

SET @SQLStatement = 'ALTER INDEX CSIX_DIM_CONSTITUENT ON [' + @RPTDWDB + '].[BBDW].[DIM_CONSTITUENT] DISABLE; '

EXEC sp_executesql @SQLStatement;

When I try to run this it says "['My_RPT_BBDW].[BBDW].[DIM_CONSTITUENT]" can not be found. Yes, I know it exists because I can see it using SQL Server Management Studio.

Has anyone run into this before?

Thank you again
Will

asked by willomalley (199 points)

Please log in or register to answer this question.

...