Viewing 15 posts - 61 through 75 (of 148 total)
Hi,
I tried with below script through sql job and its failing with below error.
script:
$dt=get-date -format "_yyyyMMMdd_HHmss"
Invoke-Sqlcmd -Query "SELECT * FROM [XXXXX].[XXX].[XXX]" -ServerInstance "LocalHost" |
Export-Csv -Path D:\folder\data$dt.csv" -NoTypeInformation
Error Message:
Executed as user:...
November 21, 2019 at 1:46 pm
Sorry I was busy with prod issue after this post .i will check your suggestions tomorrow and reply.
Thank you for your suggestions.
November 21, 2019 at 1:21 am
Thank you !!
so we will need to update the latest Cumulative updates(CU7) for sql2016 ?
June 5, 2019 at 3:32 pm
yes the firewall is already enabled and we are able to connect to other sqlservers\instances .
March 27, 2019 at 10:41 am
January 31, 2019 at 8:33 am
Thank you to both of you.
My problem solved .
January 28, 2019 at 9:15 am
August 20, 2018 at 8:39 am
You will need that certificate...
August 20, 2018 at 6:42 am
August 20, 2018 at 6:41 am
August 15, 2018 at 1:14 pm
we have multiple databases.
the secondary server is only for DR purpose.
can we use the same key for secondary installation?
August 14, 2018 at 9:16 am
master key and certificate will be removed by uninstalling the SQL server ?
August 13, 2018 at 8:36 am
adisql - Wednesday, August 8, 2018 9:09 AMThank you.
Hi,
I have one more requirement.
Planning to migrate the database from sql2008 standard to sql2016 enterprise.
But...
August 8, 2018 at 9:12 am
July 27, 2018 at 8:34 am
Viewing 15 posts - 61 through 75 (of 148 total)