Viewing 15 posts - 2,326 through 2,340 (of 2,917 total)
To me, it sound then like audrey.abbey is likely correct...
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.
September 6, 2017 at 8:18 am
Can you replicate the problem on another computer?
If you can replicate the problem, it makes me think the problem is not related to the end users computer.
If 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.
September 5, 2017 at 4:24 pm
A quick google of that error brought me to this: The above is all just my opinion on what you should do.
https://technet.microsoft.com/en-us/library/ms187005(v=sql.105).aspx
basically - update SSMS, possible network issues, server setting may need changing (depending on the windows server version).
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.
September 5, 2017 at 3:39 pm
The database they were connected to had auto-close set to false, correct? I believe that is a database level setting... I am just thinking if they are running a query...
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.
September 5, 2017 at 3:30 pm
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.
September 5, 2017 at 2:49 pm
Is the client connecting from the remote site over some form of VPN? Could there be an idle timeout in the VPN software?
When you that the connection 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.
September 5, 2017 at 2:27 pm
Well, the reason it is not returning results is your where clause.
since @Cat1 does not equal 0 AND @cat2 doesn't equal 0, one of your OR conditions needs to...
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.
September 1, 2017 at 9:08 am
I think what Perry is suggesting (correct me if I am wrong though) is that your SAN team would handle everything with this.
They would migrate the data from 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.
August 30, 2017 at 11:37 am
What about for answered threads, the thread title would have the text "ANSWERED" after it. So for this thread (presuming it was answered), it would say: "answered" thread...
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.
August 29, 2017 at 12:03 pm
Good to know. I thought it was working since the patching. Which, while true, has not had a long enough runtime to verify that it is "fixed".
Could 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.
August 28, 2017 at 2:02 pm
I would expect, since it is getting "access is denied" errors that the problem is with a specific account.
But I suppose if things are running now, it might...
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.
August 28, 2017 at 11:27 am
If you execute the stored procedure as the SQL Agent user, does it execute successfully or do you get that same error?
Since it has run successfully 3 days...
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.
August 28, 2017 at 11:06 am
Good to know.
Brings up the next question though - what is different between those 2 configuration files?
Also, was re-reading the initial post... how does the JOB call...
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.
August 28, 2017 at 10:16 am
Ok, so my next thought is what is different between the 2 configuration files you are using?
My GUESS is that they are pointing to different SQL Instances or databases. ...
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.
August 25, 2017 at 11:48 am
Adding to this, what does the "All Executions" report look like for that SSIS package (presuming you are using an SSIS catalog)?
Might not hurt to turn on verbose logging...
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.
August 24, 2017 at 2:51 pm
Viewing 15 posts - 2,326 through 2,340 (of 2,917 total)