to publish to a Local  Server you need to use Power Bi Report Server https://powerbi.microsoft.com/en-us/report-server/

Note that this is a licensed piece of software which you can use if you have...

perfectly normal. 2005 install knows nothing about the higher versions and gets confused. possibly doing a alpha compare of "9.0" vs "12.0" and 1 is less than 9.

but why in...

error is basically stating that you can not populate the destination column with itself

MyOutputBuffer.AddRow();

MyOutputBuffer.PersonID = MyOutputBuffer.PersonID;

should be

MyOutputBuffer.PersonID = my_source_value;

see the following link for some examples

https://docs.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-data-flow-script-component-types/creating-a-source-with-the-script-component?view=sql-server-2017

normally that high number of heaps means

1 - whoever designed this has a Oracle background and followed the same approach

2 - the tables are staging type tables where having the...

one possibility is that an anti-virus is causing that issue - if you got McAfee running disable it

Small apart - being a MS CRM db replication is not supported by Microsoft - be careful with that. Having said it  I have implemented it myself with no major...

please post the actual explain plan of that query so we can have a look at it.

and DDL for both temp table and main table (including all indexes)

most common issues...

If you can get procmon from sysinternals suite https://docs.microsoft.com/en-us/sysinternals/downloads/sysinternals-suite%5D and within the server itself kick it off and monitor both SQL Server and SSMS and see if it gets a...

you can buy one !!!!! https://www.adverts.ie/vintage-classic/t-55-tank-for-sale-unarmed/221665

Good reply Brandie 🙂 I wish I had the communication skills for that.

I do see the point of adding an account to all instances - I would hope it is...

Is it my impression or we are getting more cases of "professionals" asking to be supplied with fully functional scripts to solve their issues and at the same time getting...

you were given 2 options - one easy and the other requiring you do do a tiny bit of code yourself - either option are useful even if not an...

this is called being lazy - this is a task that you would not be performing that often so just creating a sqlcmd execute query command line string on the...

following will work with sample data.

constraints:

PriorityOrder always starts at 1

PriorityOrder increments by exactly 1 (e.g. there are no gaps)

with operations
as (
select *
from (values 
 (cast(1 as int),...

In SQL Server 2005 Management Studio:

View Menu -> Summary (or F7)

In SQL Server 2008 Management Studio:

View Menu -> Object Explorer Details (or F7)

pretty useless though - as soon as you...