Viewing 15 posts - 1,906 through 1,920 (of 2,917 total)
One guess on this - are you closing the connection and committing the transaction in your application code?
When I've seen "stuck transactions" like that, it is often caused by the...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 25, 2020 at 5:21 pm
Is this what you are looking for:
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 25, 2020 at 5:16 pm
I am not an expert on Browser Service either, but I am not sure it actually adds much security. If someone really wants into your system, a port probe isn't...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 25, 2020 at 4:31 pm
So just to confirm, the stored procedure is the EXACT same query?
That is, you said the following query works:
EXEC sp_execute_external_script
@language = N'Python',
@script = N'
import pandas as pd
from...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 25, 2020 at 3:19 pm
I am not sure on that one but the error is saying (based on google translate):
OSError WinError 10013 Access to a socket was not allowed due to the access rights...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 22, 2020 at 9:53 pm
Pretty sure putting the logins in the datareader role should handle this.
alternately, you could generate the script it with something like:
SELECT N'GRANT SELECT ON ' + name...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 22, 2020 at 9:40 pm
As a guess on your data, it isn't returning multiple rows in the first select subquery.
I am guessing that in the table HumanResources.Employee, the BusinessEntityID column is unique. So p.BusinessEntityID...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 22, 2020 at 9:32 pm
My understanding (experts correct me if I am wrong) is that if the conversion is potentially possible, but the conversion is invalid, then you get NULL. If the conversion is...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 22, 2020 at 8:57 pm
If it was me, I would look at encrypting by certificate OR by passphrase.
To see some TSQL on it:
Use those examples but instead of displaying to screen, store it in...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 21, 2020 at 7:54 pm
To answer question number 2 about the folders, those are version numbers. 110 is 2012, 140 is 2017, 150 is 2019.
If you installed SSMS 18, it does not come with...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 21, 2020 at 5:49 pm
I think you need to change your query a little bit to something more like this:
CREATE FUNCTION [dbo].[LastBuyer1]
(@SC1 varchar(30))
RETURNS VARCHAR(3)
AS
BEGIN
DECLARE @LB VARCHAR(3);
WITH CTE AS
(SELECT TOP 1 Buyer,...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 21, 2020 at 5:42 pm
I was following this thread because I was curious about this too. Thanks Anthony for the answer to it.
It also bring up the question, why would you want to restrict...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 21, 2020 at 3:20 pm
If you subnet mask is 255.255.255.0, then 1.2.3.x cannot see or talk to 1.2.4.x. with a subnet mask of 255.255.255.0 you can only communicate with 1.2.3.0 through 1.2.3.255.
I'd recommend reading...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 21, 2020 at 1:19 pm
Thanks for posting back especially including the solution.
Good luck with the disasters. Hopefully you do not have too many.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 20, 2020 at 10:00 pm
MAY have a solution to that:
https://bindujanga.blogspot.com/2016/03/sql-server-connectivity-issue.html
It isn't specific to SQL 2017, but may be something to look into.
To quote the article:
Windows server Event Log has many SChannel errors as below:
The...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 20, 2020 at 8:10 pm
Viewing 15 posts - 1,906 through 1,920 (of 2,917 total)