Thanks al lot , I also want to see the updates and Select is that also possible ?

Thanks Phil it seems to work !

I think i have it 

UPDATE ID 
SET ID = REPLICATE('99',10-LEN(RTRIM(ID))) + RTRIM(ID)
WHERE ID in ('100657499 ','etc ')

you can also use the Microsoft Kerberos Configuration Manager for SQL Server

https://support.microsoft.com/en-us/help/811889/how-to-troubleshoot-the-cannot-generate-sspi-context-error-message

You can also use this tool from Microsoft 

Microsoft® Kerberos...

You can use SQL profiler for that

Maybe handy ?

Exec sp_MSForEachDB 'SELECT

CONVERT(varchar(100), SERVERPROPERTY(''Servername''))

AS Server,

''?'' AS DB_Name,usu.name u_name,

CASE WHEN (usg.uid is null) THEN ''public''

ELSE usg.name

END as Group_Name,

CASE WHEN usu.isntuser=1 THEN ''Windows Domain

Account''

WHEN usu.isntgroup = 1 THEN ''Windows...

If you want to create a new log use sp_cycle_errorlog

It won't make any difference in SSIS, I think it's the best option to use SSIS (data flow task).

Have you read these documents they are very handy

http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/Building%20a%20High%20Availability%20and%20Disaster%20Recovery%20Solution%20using%20AlwaysOn%20Availability%20Groups.docx

http://www.sqlservercentral.com/articles/AlwaysOn/91408/

You can also use WinSCP for uploading the backup file.

Then you can use serveral scripts or command line code and put it in an agent jobstep.

Thanks, that works fine!!

Thanks i will have a look at it, andit look fine and it works but i only whant to see the data after the = sign is that possible?

Thnx i will try that