Viewing 15 posts - 7,066 through 7,080 (of 39,963 total)
You can capture the output of the script and execute it directly instead of using xp_cmdshell.
April 21, 2017 at 8:06 am
You would need to do the inserts one at a time.WITH myTally(n)
AS
(SELECT n = ROW_NUMBER() OVER (ORDER BY (SELECT null))
FROM (VALUES (1), (2),...
April 21, 2017 at 8:04 am
April 20, 2017 at 9:48 am
April 20, 2017 at 9:31 am
April 20, 2017 at 9:29 am
April 19, 2017 at 2:12 pm
Good summary from Lowell, but I'll add a couple simple thoughts.
Column encryption is is designed when you trust the server, not the client. You need to trust admins...
April 19, 2017 at 12:04 pm
apt-get update
apt-get install mssql-server
I like Linux updates.
April 19, 2017 at 11:32 am
April 18, 2017 at 11:16 am
This appears to be an issue with IO not being able to be frozen: https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-os-wait-stats-transact-sql
Did previous log restores complete? Are you restoring in standby or norecovery?
April 18, 2017 at 10:46 am
April 18, 2017 at 10:35 am
My suspicion is that there is one of two things happening.
1. The powershell exe isn't firing for the account in services (not in path, or something else)
2....
April 18, 2017 at 10:28 am
That looks like an incomplete command. Do you have Powershell as the program being run? Are you use this is in the path for the system?
I'd do something...
April 18, 2017 at 10:02 am
Viewing 15 posts - 7,066 through 7,080 (of 39,963 total)