Thank you for your suggestion. How to create the linked server. Please help me for that one like sample script.

Regards

Pols

table convert into text file then it is size almost 60GB.daily we can't create text file then restore another server and it is also time taken process. Please suggestion another...

In table 4000000 records .backup is not possible total database size is 1TB.

Database is full recovery model.when copy the table in single table also take time more and copy of the table is INTO statement.

created new database it is also take time more....

Database is Full Recovery Model...it is not possible to change Bulk logged recovery model

I am using the query is

SELECT id,name,xmldata INTO New_Table Name from TableName

i am using same database that is duplicate of another table ....

table don't have the any indexs it is use only transaction purpose like only insert statement when i create...

SELECT

Operation,

[Transaction Id],

[Transaction SID],

[Transaction Name],

[Begin Time],

[SPID],

Description

FROM fn_dblog (NULL, NULL)

WHERE [Transaction Name] = 'DROPOBJ'

is not available in Azure?

Still Not Working...

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 16 (2019-04-19T14:45:36). Exception Message: Cannot send mails to mail server. (Failure...

Allow less secure apps ON but it is not working...error message

The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 9...

i am using my personal mailid like my code is

--Creating a Profile

EXECUTE msdb.dbo.sysmail_add_profile_sp

@profile_name = 'SQLProfile',

@description = 'Mail Service for SQL Server';

-- Create a Mail account for gmail. We have to...

• This reply was modified 5 years, 8 months ago by  polo.csit.

Thank you...