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 email@example.com.
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)
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