linked server sql

 SELECT * FROM OPENQUERY([ProdServer], 'SELECT * FROM ICSForTeams.dbo.Auth_users')

INSERT INTO AnalyticsCx.DBO.AUTH_USERS([EmailId], [PhoneNumber], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [TenantId], [UserGUID], [DisplayName], [JobTitle], [LanguageLocal], [IsDeleted], [DateCreated], [DateLastModified], [StreetAddress], [State], [CountryID], [OfficeAddress], [City], [Zip], [TimezoneID], [IsAdmin], [IsAnalytics], [IsSubscribed], [TrialFinishDate], [UserPhoto], [ManagerUserId], [IsReportingAccess], [IsLoginDisabled], [IsMicrosoftAuthentication], [PeopleAdminAccessTypeId], [IsDirectReportAccess], [IsMyPeopleAccess], [ManagerGUID], [ReportingAccessTypeId], [IsMSCommunicationInstance], [IsLicensed], [UserPrincipalName], [DefaultWallboardId], [ShowWelcomeScreen])

SELECT [EmailId], [PhoneNumber], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [TenantId], [UserGUID], [DisplayName], [JobTitle], [LanguageLocal], [IsDeleted], [DateCreated], [DateLastModified], [StreetAddress], [State], [CountryID], [OfficeAddress], [City], [Zip], [TimezoneID], [IsAdmin], [IsAnalytics], [IsSubscribed], [TrialFinishDate], [UserPhoto], [ManagerUserId], [IsReportingAccess], [IsLoginDisabled], [IsMicrosoftAuthentication], [PeopleAdminAccessTypeId], [IsDirectReportAccess], [IsMyPeopleAccess], [ManagerGUID], [ReportingAccessTypeId], [IsMSCommunicationInstance], [IsLicensed], [UserPrincipalName], [DefaultWallboardId], [ShowWelcomeScreen] FROM OPENQUERY([ProdServer], 'SELECT [UserId], [EmailId], [PhoneNumber], [LockoutEndDateUtc], [LockoutEnabled], [AccessFailedCount], [TenantId], [UserGUID], [DisplayName], [JobTitle], [LanguageLocal], [IsDeleted], [DateCreated], [DateLastModified], [StreetAddress], [State], [CountryID], [OfficeAddress], [City], [Zip], [TimezoneID], [IsAdmin], [IsAnalytics], [IsSubscribed], [TrialFinishDate], [UserPhoto], [ManagerUserId], [IsReportingAccess], [IsLoginDisabled], [IsMicrosoftAuthentication], [PeopleAdminAccessTypeId], [IsDirectReportAccess], [IsMyPeopleAccess], [ManagerGUID], [ReportingAccessTypeId], [IsMSCommunicationInstance], [IsLicensed], [UserPrincipalName], [DefaultWallboardId], [ShowWelcomeScreen] FROM ICSForTeams.dbo.Auth_users')

SELECT STRING_AGG(QUOTENAME(COLUMN_NAME), ', ') AS column_list

FROM (

    SELECT COLUMN_NAME

    FROM AnalyticsCx.INFORMATION_SCHEMA.COLUMNS

    WHERE TABLE_NAME = 'AUTH_USERS'

      AND TABLE_SCHEMA = 'dbo'

) AS columns;
==================

sqlcmd  -S ABDUL-RAHMAN\SQLEXPRESS -d Anlytics365CX_2025V2 -i "C:\Users\Tollring\Documents\QA_2025script.sql" -x

USE [master]

GO

CREATE LOGIN [ABDUL-RAHMAN\Tollring] FROM WINDOWS

GO

USE Analytics365CX_2025V2

GO

CREATE USER [ABDUL-RAHMAN\Tollring] FOR LOGIN [ABDUL-RAHMAN\Tollring]

GO

EXEC sp_addrolemember N'db_datareader', N'ABDUL-RAHMAN\Tollring'

EXEC sp_addrolemember N'db_datawriter', N'ABDUL-RAHMAN\Tollring'

GO

===========