Viewing 15 posts - 1,111 through 1,125 (of 2,919 total)
Quick google of that error, it sounds like there is more to the error message. Is the full error message:
Msg 8921, Level 16, State 1, Line 1 Check terminated. A...
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.
June 18, 2021 at 4:47 pm
I see a few optimizations that can probably take place.
First, that WHERE 1=1 isn't needed as it isn't doing anything. Not sure it is a performance improvement by removing it,...
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.
June 18, 2021 at 4:27 pm
One way to do it that I think should work would be to do a self join. So something like:
SELECT
[t1].[empID]
, [t1].[empl_rcd]
, [t1].[jobcode] AS [jobcode1]
, [t1].[joblevel]...
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.
June 18, 2021 at 3:37 pm
For me, with my android device, I like that I can turn off targeted marketing. I forget where the setting is, but google allows you to disable it. Turning it...
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.
June 18, 2021 at 2:16 pm
I can think of only 1 case where a BEGIN doesn't have an END - BEGIN TRANSACTION. That requires a COMMIT or a ROLLBACK. Otherwise I agree with Jeff here...
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.
June 17, 2021 at 8:36 pm
Few things I would try, but the first would be to connect to the server using the FQDN rather than the friendly name.
I would also make sure your connection string...
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.
June 17, 2021 at 8:31 pm
If the password to the SSIS service account is known to you, I would log in as that account and do a test run of the powershell as the SSIS...
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.
June 17, 2021 at 3:20 pm
Do you have access to the folder where backups are happening on the live system? If so, restore the live database onto your test box and run some tests 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.
June 17, 2021 at 3:03 pm
@loaderror - I don't think that you need to have the server name match the SQL instance name as then you wouldn't be able to have multiple named instances on...
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.
June 17, 2021 at 2:03 pm
My first step - check the logs.
My second step - adjust the powershell script to write to a debug file so you can see where it is getting stuck. 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.
June 16, 2021 at 5:26 pm
As far as I know, this is a manual process. If you NEED to change the table but don't want to change all of the objects using that table, you...
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.
June 16, 2021 at 5:15 pm
With your ROUND, you are rounding to 3 decimal places so that is why you are getting a bunch of 0's.
So your options are:
1 - change your ROUND to be...
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.
June 15, 2021 at 9:59 pm
As a thought, are your SPN's set up correctly?
I know I hit that snag YEARS back and I found a SO article about that error message where they are reminded...
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.
June 15, 2021 at 9:51 pm
Might be a silly question but did you set up both the web portal and web service for SSL?
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.
June 15, 2021 at 7:18 pm
I would probably take this approach (although not that efficient, it is easy to read in my opinion):
where (p.JCCo=@Company and p.Job=@Job and substring(Phase,1,3) not in (' 00','...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.
June 15, 2021 at 5:39 pm
Viewing 15 posts - 1,111 through 1,125 (of 2,919 total)