look at https://stackoverflow.com/questions/39058510/cant-install-microsoft-sql-server-because-of-vssaccesscontrol

and other results from google https://www.google.com/search?q=Error+installing+SQL+Server+Writer+Component+Could+not+write+value+NT+SERVICE%5CSQLWriter+to+key&sourceid=chrome&ie=UTF-8

but this leads to the question - why do you need to remove them? they are valid characters and if the output is being displayed anywhere for users removing those...

• This reply was modified 2 years, 11 months ago by frederico_fonseca.

as a start I would look at AV on that server - it may be scanning things that were excluded on prior server.

different powershell versions may also cause issues -...

What is the business case here for replication?  HADR? Readable copies for reporting etc?

With replication, you can always start the subscriber from a backup, rather than doing a snapshot....

have a look at https://social.msdn.microsoft.com/Forums/en-US/24364f85-6b3d-45d1-b54d-a739b3b64b80/add-linked-server-access-mdb-access-2007-accdb-file-in-sql-server-2008?forum=aspdatasourcecontrols

you do need to have those 2 props to 1, and you also need a login setup if not mistaken.

and you need to ensure that the...

you do it as part of the create table - or you specify every single field on your select.. into and on that you do a convert(decimal(19, 6), fieldx) as...

issue you have is that your TotalAmount column is a decimal (18, 6) - the PIVOT sum then outputs this as decimal(38, 6) which takes 17 bytes each.

so 597 *...

Jet is a 32 bit technology - won't work with newer versions of SQL (which are all 64 bit)

you need to use Microsoft ACE instead https://www.microsoft.com/pt-pt/download/details.aspx?id=50040

1. table on a dba database to store the database details of the server (or even all your servers).
2. weekly sql job to retrieve the details of databases and add...

if not mistaken on this case the index spool is because your archive table is partitioned (on a column other than GSN_ID, most likely TNR_DATE) and SQL creates the spool...

how big is the table?

if only a few thousand rows then a script with insert statements would likely work fine as mentioned before.

but for anything with volumes BCP or powershell...

Another option if you don't want to be moving data between your local and the prod server, creating temp tables, CTE's etc... would be to use SSIS and just...

• This reply was modified 3 years ago by frederico_fonseca.

replacing the CR + LF on a text field IS losing data - maybe not important on your case, but it is still data.

In one of the migrations on my...

what worked? creating a valid CSV file or removing potentially valid data from your output? and if removing valid data...

not as easy as that. the environment within a SQL job step is a number related to the number of the environment on that particular server.

trying to recreate the same...