Forum Replies Created

Viewing 15 posts - 1,171 through 1,185 (of 1,493 total)

  • RE: Help merging NOTES (text) field

    Sean Lange (12/9/2014)


    Don. (12/9/2014)


    djj (12/9/2014)


    First is there a reason you are using TEXT? Why not VARCHAR(MAX)? From BOL

    ntext, text, and image data types will be removed in a...

  • RE: Today's Random Word!

    Holiday

  • RE: Help merging NOTES (text) field

    First is there a reason you are using TEXT? Why not VARCHAR(MAX)? From BOL

    ntext, text, and image data types will be removed in a future version of Microsoft...

  • RE: Implicit Conversions

    There is no conversion for character size. From Varchar to NVarchar is a implicit conversion. See BOL "CAST and CONVERT (Transact-SQL) " for table

  • RE: Today's Random Word!

    Ed Wagner (12/3/2014)


    Stuart Davies (12/3/2014)


    Ed Wagner (12/3/2014)


    SQLRNNR (12/3/2014)


    BWFC (12/3/2014)


    Requirements 🙂

    Make em up as you go;-)

    Cowboy diplomacy

    Samuel Colt

    John Browning

    rifleman (old TV show)

  • RE: database growth

    Notice that a database is not just tables and indexes.

  • RE: Non-explanatory backup error message

    As I bang my head on the wall. Duh!

      12/02/2014 21:15:02,Backup,Unknown,BACKUP failed to complete the command BACKUP DATABASE MyDatabase. Check the backup application log for detailed messages.

      12/02/2014 21:15:02,Backup,Unknown,Error: 3041<c/> Severity: 16<c/>...

    • RE: xp_cmdshell issues

      Emil Bialobrzeski (12/3/2014)


      djj (12/3/2014)


      I am no security expert but what about EXECUTE AS?

      http://www.sqlservercentral.com/articles/Execute+AS/71673/

      Thats one option.

      The other one is to use a signed stored procedure. This is definetly more secure option...

    • RE: xp_cmdshell issues

      I am no security expert but what about EXECUTE AS?

      http://www.sqlservercentral.com/articles/Execute+AS/71673/

    • RE: Today's Random Word!

      Ed Wagner (12/2/2014)


      djj (12/2/2014)


      Ed Wagner (12/2/2014)


      whereisSQL? (12/2/2014)


      Ed Wagner (12/2/2014)


      SQLRNNR (12/2/2014)


      Ed Wagner (12/2/2014)


      SQLRNNR (12/2/2014)


      Stuart Davies (12/2/2014)


      Ed Wagner (12/2/2014)


      crookj (12/1/2014)


      SQLRNNR (12/1/2014)


      Sean Lange (12/1/2014)


      Steve Jones - SSC Editor (12/1/2014)


      Work

      Avoidance

      No play

      Play for Free.....

      Fun

      sized

      SHORT

      Time

      Slipping

      Future

      Present

      History

      Past

      Study

      late night

    • RE: Today's Random Word!

      Ed Wagner (12/2/2014)


      whereisSQL? (12/2/2014)


      Ed Wagner (12/2/2014)


      SQLRNNR (12/2/2014)


      Ed Wagner (12/2/2014)


      SQLRNNR (12/2/2014)


      Stuart Davies (12/2/2014)


      Ed Wagner (12/2/2014)


      crookj (12/1/2014)


      SQLRNNR (12/1/2014)


      Sean Lange (12/1/2014)


      Steve Jones - SSC Editor (12/1/2014)


      Work

      Avoidance

      No play

      Play for Free.....

      Fun

      sized

      SHORT

      Time

      Slipping

      Future

      Present

      History

      Past

    • RE: Today's Random Word!

      Ed Wagner (12/1/2014)


      djj (12/1/2014)


      Ed Wagner (12/1/2014)


      whereisSQL? (12/1/2014)


      SQLRNNR (12/1/2014)


      Stuart Davies (12/1/2014)


      Ed Wagner (12/1/2014)


      crookj (12/1/2014)


      Ed Wagner (12/1/2014)


      SQLRNNR (12/1/2014)


      Ed Wagner (12/1/2014)


      Stuart Davies (12/1/2014)


      Ed Wagner (12/1/2014)


      SQLRNNR (11/30/2014)


      Jeff Moden (11/30/2014)


      Ed Wagner (11/30/2014)


      SQLRNNR (11/29/2014)


      Junk (ship)

      Scuttle

      Being a...

    • RE: Server log "SQL Trace" start and stop

      The culprit is the compliance manager. According to Idera the only fix is to keep all error messages from the Windows Event Log. From Idera solutions:

      Solution Number 00001798...

    • RE: Server log "SQL Trace" start and stop

      That could be. I am using a couple of Idera products (dm and cm). I will look into these.

      Thanks!

    • RE: Today's Random Word!

      Ed Wagner (12/1/2014)


      whereisSQL? (12/1/2014)


      SQLRNNR (12/1/2014)


      Stuart Davies (12/1/2014)


      Ed Wagner (12/1/2014)


      crookj (12/1/2014)


      Ed Wagner (12/1/2014)


      SQLRNNR (12/1/2014)


      Ed Wagner (12/1/2014)


      Stuart Davies (12/1/2014)


      Ed Wagner (12/1/2014)


      SQLRNNR (11/30/2014)


      Jeff Moden (11/30/2014)


      Ed Wagner (11/30/2014)


      SQLRNNR (11/29/2014)


      Junk (ship)

      Scuttle

      Being a former submarine sailor,...

    Viewing 15 posts - 1,171 through 1,185 (of 1,493 total)