Viewing 15 posts - 586 through 600 (of 2,857 total)
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.
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...
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...
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...
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...
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...
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...
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
...
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. ...
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...
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...
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...
February 8, 2022 at 5:01 pm
My opinion - blocking outgoing traffic is only required if there is a risk of the server being compromised. If you can download and install arbitrary applications on the server...
February 7, 2022 at 3:01 pm
If I understand your question right, you are asking if you can add an index to a table on production while users are using the table. If so, yes. It...
February 4, 2022 at 5:21 pm
Found an old article on this, but I expect it is still valid:
I would recommend doing it on a test system first and trying things out and once you are...
February 4, 2022 at 3:40 pm
Viewing 15 posts - 586 through 600 (of 2,857 total)