Forum Replies Created

Viewing 15 posts - 2,851 through 2,865 (of 2,917 total)

  • RE: Help with Instead of Trigger

    There is also some weirdness with your code.  Your:
    SELECT @code
    FROM inserted 

    line is strange.  You don't need a FROM when you are just selecting the variable.

    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: It's about encryption key

    p.shabbir - Monday, February 13, 2017 10:06 AM

    bmg002 - Friday, February 10, 2017 2:34 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: SQL Server DBA training.

    Jeff Moden - Monday, February 13, 2017 7:58 AM

    Kevin3NF - Sunday, February 12, 2017 5:54 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: t-sql 2012 update statement

    Siten0308 - Friday, February 10, 2017 9:53 AM

    Hey Wendy,

    I had a problem similair to that a while back, one thing i did...

    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 Server DBA training.

    I actually started as an electronics assembler, then moved up to Tier 1 IT (Have you tried turning it off and on again? <-- I used that line a lot...

    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: Insert into linked server

    Sue_H - Friday, February 10, 2017 12:00 PM

    Sometimes you can pick up errors using Profiler. Some of the events in OLE...

    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: It's about encryption key

    p.shabbir - Friday, February 10, 2017 12:35 PM

    Hi All,
    In know it's irrelevant to sql server but, hope somebody can help or let...

    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: Performance improves after reboot

    RVO - Friday, February 10, 2017 1:13 PM

    jonathan.ellison - Friday, February 10, 2017 5:21 AM

    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.

  • RE: tempdb Initial Size (MB)

    RVO - Friday, February 10, 2017 12:41 PM

    Why is it called "Initial Size (MB)" in tempdb properties in SSMS?
    It is current file...

    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: Query works until I use it in a stored procedure (contains forward slash)

    pharmkittie - Thursday, February 9, 2017 12:53 PM

    Y.B. - Thursday, February 9, 2017 12:43 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: I can't query SQL Server over internet

    Sue_H - Thursday, February 2, 2017 1:46 PM

    WebTechie - Thursday, February 2, 2017 1:33 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: Any way to guesstimate internet needs for remote DBA?

    Eirikur Eiriksson - Friday, February 3, 2017 7:51 AM

    Back in the old days I was managing several mission critical database servers using...

    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: Issue with column - showing as invalid column

    mcfarlandparkway - Thursday, February 2, 2017 12:50 PM

    ALTER TABLE [dbo].[emp] ADD [ID] INT IDENTITY(0000001, 1)

    SELECT IR.JournalSource,
               RIGHT('0000000' + CAST(IR.[ID] AS VARCHAR(30)), 7)
    INTO...

    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: Deciding on being Developer or DBA

    Xedni - Thursday, February 2, 2017 1:12 PM

    Hi All,

    This is a soft question, and one I've seen asked elsewhere, but differently enough...

    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: Any way to guesstimate internet needs for remote DBA?

    Another thing to remember is that hotspotting will eat your battery more.  You may want to watch how much your battery is hit by using hotspot.  I've seen cases where...

    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,851 through 2,865 (of 2,917 total)