Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 2,917 total)

  • RE: SQL Agent can't run PowerShell Script - just hangs

    I have 2 thoughts:
    1 - are you using a network share for the excel file and if so, are you using UNC paths?
    2 - does your SQL Server...

    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.

  • RE: Could not find package error message.

    Did you provide the full path to the package?

    What is the full command you are running?  Seeing the arguments you provided will likely help resolve the issue.

    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.

  • RE: EXEC xp_cmdshell 'Powershell.exe

    rajju_vini - Thursday, March 16, 2017 12:24 PM

    HI,

        Have a problem not sure if its permission issue or something else, any...

    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.

  • RE: Unable to fetch result from linked server

    Narine M - Thursday, March 16, 2017 3:23 PM

    The SAO server in different domain , whether it may cause any issue.?????

    Depends 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.

  • RE: Unable to fetch result from linked server

    Narine M - Thursday, March 16, 2017 11:09 AM

    Yes, i looked in to the post, whether the uninstallation and reinstallation of...

    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.

  • RE: Encapsulating complex logic without using a scalar UDF

    ScottPletcher - Thursday, March 16, 2017 8:52 AM

    Jeff Moden - Wednesday, March 15, 2017 6:21 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.

  • RE: Unable to fetch result from linked server

    Narine M - Thursday, March 16, 2017 2:07 AM

    The query is working fine in all servers, expect SAO server.. Checked the linked connections using the simple select query it's working fine...in that query it fetches the result from SAO server, through linked server connections...But it error outs...

    did you look at that link I posted?

    Also, did you compare the linked...

    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.

  • RE: Need to know what I should install for my SQL

    bubby - Wednesday, March 15, 2017 10:23 AM

    Virtual Machine please

    That is the most expensive route if memory serves.  If I remember correctly,...

    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.

  • RE: Dynamic Sql Query

    Oh, Lynn... Your code does have that join/where that I mentioned, but you do it on tbl1 which is Thin_water.  The original was on tbl2 which is Water_Derivation.

    I read...

    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.

  • RE: Dynamic Sql Query

    Lynn Pettis - Wednesday, March 15, 2017 9:48 AM

    bmg002 - Wednesday, March 15, 2017 9:26 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.

  • RE: Dynamic Sql Query

    Lynn Pettis - Tuesday, March 14, 2017 6:48 PM

    Is this what you are trying to accomplish?  (Please note I commented out 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.

  • RE: Unable to fetch result from linked server

    It would probably be handy if we had:
    1 - the code being run that is failing
    2 - the linked server connection information

    I was re-reading the original...

    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.

  • RE: Dynamic Sql Query

    Is this some sort of homework assignment?  I am confused what "Answer 10" is supposed to be.

    but there are a few odd things in your code.  Like why...

    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.

  • RE: Production SSRS Report Issue

    Sue_H - Tuesday, March 14, 2017 2:53 PM

    bmg002 - Tuesday, March 14, 2017 11:30 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.

  • RE: Encapsulating complex logic without using a scalar UDF

    patrickmcginnis59 10839 - Tuesday, March 14, 2017 2:02 PM

    "While I agree it should be a single update statement, lets say you 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.

Viewing 15 posts - 2,716 through 2,730 (of 2,917 total)