Ive just been looking for an SSRS word cloud and found this

https://www.sqlshack.com/r-script-word-cloud-sql-server-report-builder/

which looks like it could be the answer  - i'd worked out how to do the sql/R bit...

yeah, the error was there as originally the delete was trying to use an alias to the table, further on in the SP it enters new data and wasn't referencing...

I dropped this in so I can see what its doing which is how I resolved the...

windows 7 (32 bit) laptop with SQL 2014

Microsoft SQL Server Management Studio12.0.2269.0

Microsoft Analysis Services Client Tools12.0.2000.8

Microsoft Data Access Components (MDAC)6.1.7601.17514

Microsoft MSXML3.0 4.0 5.0 6.0

Microsoft Internet Explorer9.11.9600.18124

Microsoft .NET Framework4.0.30319.34209

Operating...

There is a mismatch in estimated count of 17 vs actual of 13k, this becomes visible after the join to the table with the suggested missing index. Not really in...

created a system DSN using native client and setting multisubnetfailover property

then

EXEC master.dbo.sp_addlinkedserver @server = N'servername', @srvproduct=N'', @provider=N'MSDASQL', @datasrc=N'dsn_name', @provstr=N'Driver={SQL Server}'

haven't tested what happens in the event of a failover...

I used both suggested methods on a windows server 2012 with SQL2012 Stadard and get the message that the data source cant be initialised

All set to Allow all connections

Thanks, I have a listner and after shuting down the primary by using the listener as the access point I have access to the database. The database was fully accessible...

Perry Whittle (3/12/2014)

The readable secondary is not important at this time, what are the connection settings when in the primary role...

Yes I am scrambling my terminology - High availability uses clustering serivices but isnt a cluster apologies for mangling my terms.

So by using the listener as the client access...

Because I simulated a failure by closing down the test1 server, the sql HA cluster failed over to test2 as expected, the windows cluster with a dns record of SQLHA...

the most obvious thing from my last post is that i need a new keyboard

I didnt have a listener but i do now, I also altered the advanced policies of the cluster exclude the two manual failover boxes from being hosts.

I am...

Do you really need to create your own shapefiles - there are plenty of freely availble ones out there and utilities to help you import them into table in SQL....