Okay folks... day 3 and I'm currently awaiting today's action to create a listener...  However....  There IS a listener in our production environment, and just to try and test things,...

Jeff,

Pretty sure you've nailed it...   I think we need a listener, and there isn't one.   I know for sure the server name of the primary, and it seems unlikely that...

Intriguing Jeff... but you'll need to go into slightly more detail....  I know for certain that the server I am referencing is the PRIMARY for that database.   It is where...

• This reply was modified 8 months ago by  sgmunson. Reason: Additional context based on Google search

Okay... new update.... take out the CTE entirely, and just try to test the concept, and suddenly I have a syntax error with "too many prefixes" for the object name. ...

As it turns out, my error is NOT from the DROP TABLE IF EXISTS statement.   It is the:

...
')
SELECT SD.*
' + CASE
WHEN @FileFrom = 'ONETIME' THEN 'INTO '...

The database is part of an AG group, but the server it is on is the publisher and is thus where we go when we need to make changes.   I'm...

Yep... this is an EXTREMELY POOR WAY TO GO ABOUT IT...   And for those folks not yet working with SQL Server 2022,  Ken McKelvey's suggested link to Jeff Moden's DelimitedSplit...

That's handy, Michael, but we're not ready as a company to embrace the use of PowerShell.   I'm going to create a new table that we can refresh via a SQL...

Indeed, the problem is primarily one of scheduling.   But now that you mention it, simply moving the stored procedure into a SQL Agent Job and having it TRUNCATE and then...

• This reply was modified 1 year, 9 months ago by  sgmunson. Reason: grammar correction

@orbit,

As to the index, searching for the CHECKSUM value that is indexed will certainly work well, and maybe the primary question is how large the rest of the...

Refresh schedule availability is based on the license level of PowerBI, but it can be refreshed manually more frequently.

I would question what utility refreshing that frequently actually has for...

you talking about power bi report server on prem or Power Bi service on cloud? if on prem scheduling is the same as with SSRS (PBIRS is a superset...

I'm really curious as to the why behind adding a checksum value to the table, based on a column named "Message", while then including the column named "Time", that somehow...

This is the primary cause of the problem.  If you have different...

Then I guess I have to ask just how many packages you have in a single project?   If that answer is more than 3, then I question the project design. ...

• This reply was modified 2 years ago by  sgmunson. Reason: Hit submit before I was done typing