Forum Replies Created

Viewing 15 posts - 2,371 through 2,385 (of 2,917 total)

  • RE: SQL Script Management Tool - Open Alpha Test

    If you have an MSDN license, you could just spin up a windows 7 VM for testing it.  Since you didn't use WPF, I can't think why it wouldn't work...

    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: SQL Script Management Tool - Open Alpha Test

    Was just looking at the application and I am a little confused about it.  

    At the moment, I am not sure how this is much different than just...

    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: Cursor

    Can we get some DDL and sample data to work with?
    The way that that is now, I don't understand what the data looks like nor why you'd need 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.

  • RE: Bidirectional Failover on SQL Server Standard Edition

    We actually have that set up where I work.  Although we use a 3rd party tool called DxEnterprise (I do not work for them).  If you have used Polyserve before,...

    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: No Columns Listed in OLE DB Source Editor Window

    Then I am not sure.  Sorry about that.  I've not seen that before except when I end up with an unnamed column.
    Any chance that 2 columns ended up with...

    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: Replace names

    Without seeing the data, I would try something like:
    BEGIN TRANSACTION;
    SELECT MISCCODE FROM table;
    UPDATE table
    SET MISCCODE = MISCCODE + '1'
    WHERE MISCCODE NOT LIKE ''
    AND...

    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: No Columns Listed in OLE DB Source Editor Window

    are your columns named?

    That is, if you are using aggregates, are you providing an alias to the column?
    Like a "SELECT SUM(dollars) FROM table" won't have a column...

    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: Potential presentation idea: So you want to be a SQL Saturday speaker?

    Ed Wagner - Tuesday, August 1, 2017 9:07 AM

    bmg002 - Tuesday, August 1, 2017 8:38 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: Login error - The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

    Has this ever worked?
    Is there a different SQL instance you can successfully connect to on the network from your local machine?

    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: Potential presentation idea: So you want to be a SQL Saturday speaker?

    Ed Wagner - Monday, July 31, 2017 7:03 PM

    bmg002 - Wednesday, July 26, 2017 2: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.

  • RE: Login error - The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)

    I may be mistaken on this one, but I THINK the service account not being able to talk to AD can cause that problem too.
    Might want to check 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.

  • RE: Creating a Robust SSIS Development Environment using the SSIS Catalog

    reinis - Monday, July 31, 2017 11:06 AM

    bmg002 - Monday, July 31, 2017 10:27 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: Creating a Robust SSIS Development Environment using the SSIS Catalog

    reinis - Monday, July 31, 2017 9:43 AM

    bmg002 - Monday, July 31, 2017 9:28 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: Creating a Robust SSIS Development Environment using the SSIS Catalog

    What we do where I work is have the environment set up for the connection managers instead of for an environment.  That way, anything we deploy to test, regardless 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: Converting XML

    Tom_Hogan - Friday, July 28, 2017 7:06 AM

    Stewart "Arturius" Campbell - Thursday, July 27, 2017 11:40 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.

Viewing 15 posts - 2,371 through 2,385 (of 2,917 total)