Viewing 15 posts - 1,591 through 1,605 (of 2,917 total)
My opinion - the execution log on the task scheduler is not the approach I would take. That will tell you the success/error code for the last command executed. If,...
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 26, 2020 at 6:54 pm
To me this sounds like either:
A - permissions
B - drive letter vs FQDN
I would check that SVCSQL$ has permissions to the files and folders and also check if "D:\TEST" 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.
August 26, 2020 at 5:16 pm
I think the best way to find individuals from this forum would be to post what the project is and hope someone interested comes along. That or reach out 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.
August 26, 2020 at 2:48 pm
I expect that you have either 2 Tablix's in the report OR you have the hidden property set on the column of the single Tablix that has your data 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.
August 26, 2020 at 2:26 pm
I think I understand why the consultants you found were costing $200/hour... that is a high list of demands for the consultant. I think if you want someone who 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.
August 25, 2020 at 9:05 pm
My opinion - it is tricky to find good ones, but not impossible. Find some reputable people in the SQL World and ask them like you did on this forum.
As...
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, 2020 at 4:33 pm
your CASE statement needs an END on it before the AS.
That should fix it for 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.
August 25, 2020 at 4:11 pm
To add to Grant's post, Idera and Quest both have good monitoring tools too.
But if all you care about is uptime, how frequently are you needing to check that 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.
August 25, 2020 at 3:06 pm
Is your linked server is pointing to the same TNSnames file that you modified (possibly a copy of the file on the SQL Server itself or maybe on a network...
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, 2020 at 7:57 pm
I expect you could change your function so it returns something rather than nothing when the PartNumber is a value like VJ0805AIR5CXAMT.
Failing that, UNION or a join should work 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.
August 24, 2020 at 6:13 pm
Sounds like the SQL agent for some reason isn't able to see the files then.
As a thought, what if you remove the filter and run the powershell of just getting...
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 21, 2020 at 10:03 pm
is the path to the DataDomain repository a network share (such as a Z:\ drive)? if so, try using the fully qualified domain name.
Failing that, comment out the last bit...
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 21, 2020 at 7:11 pm
I'm confused... in your first reply, you said there was no SSIS package and now you are saying there are SSIS packages?
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 17, 2020 at 4:48 pm
While I agree that hiring a lot of contractors for a complicated project produces a complicated result; it does really depends on the contractors. If you hire web developers 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.
August 17, 2020 at 4:37 pm
As Eirikur Eiriksson said, without data, it is hard for us to help you.
But lets assume that all of your columns are in a format that meets your sample data. ...
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 17, 2020 at 3:52 pm
Viewing 15 posts - 1,591 through 1,605 (of 2,917 total)