Viewing 15 posts - 646 through 660 (of 2,917 total)
First thing I notice is that your code for a new user is not using AD. You'd want a "FROM WINDOWS" not "WITH PASSWORD" for using AD.
Next, if I am...
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.
March 2, 2022 at 5:45 pm
Since the SELECT takes 11 minutes like the UPDATE, it sounds to me like the data lookup process is what is so slow. I would look at your execution plan...
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.
February 18, 2022 at 7:34 pm
aaradhya - I think the app is DOA. Looking at the link, they have had 10 downloads and it hasn't been updated since December 2020 and personally, I think 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.
February 18, 2022 at 2:26 pm
Pretty sure it depends on your data. I recommend posting some sample data, some DDL, and your expected results so we have something to go on and test.
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.
February 17, 2022 at 9:42 pm
My thoughts, if it isn't the software firewall, do you have a hardware firewall that your IT team needs to configure?
Alternately, it could be a routing problem. Depending on your...
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.
February 17, 2022 at 2:22 pm
Might not hurt to check firewall settings. Could be that something was recently set up (intentional such as something to improve security, accidental such as a GPO that should have...
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.
February 16, 2022 at 9:18 pm
To add to what Michael is saying, if you DO get results BUT the results are "NULL" (the literal NULL, not a string), then your variable will also come back...
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.
February 16, 2022 at 2:26 pm
My opinion - storing PDF's in an IMAGE datatype column is just wrong. Mind you, I try not to use SQL for storing documents in general, but it sounds like...
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.
February 10, 2022 at 8:19 pm
I would check the error log. The log is ONLY cycled if you force it to (I believe). It can be forced with a command or with a restart. 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.
February 10, 2022 at 2:44 pm
I am pretty sure Javascript is going to give you the same limitation. Pretty sure that Javascript will need a trigger to tell them to pick 10 or fewer options...
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.
February 9, 2022 at 3:28 pm
Personally, I wouldn't worry about the javascript part of it. I would handle it in the TSQL. Have the TSQL be something like
IF (TooManySelected > 10)
BEGIN
...
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.
February 8, 2022 at 10:05 pm
Since you got no replies, my guess is nobody here has tried it. My suggestion would be to try it out and see if it works like how you expect. ...
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.
February 8, 2022 at 9:11 pm
Just to step back a bit - you indicated that you have 1 SQL instance per VM and the ones without AG's are working fine, but everything in an AG...
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.
February 8, 2022 at 7:37 pm
The error from Chome should tell you that things are not set up properly.
My GUESS is you didn't add a script map for the PUMP dll. You didn't list that...
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.
February 8, 2022 at 5:05 pm
Licensing is a question best answered by your licensing provider. Forum answers are going to be guesses based on what WE have seen, and you may have some deal 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.
February 8, 2022 at 5:01 pm
Viewing 15 posts - 646 through 660 (of 2,917 total)