SQL Server truncation and 8192 limitation

by

You can export the data to a flat file which will not be truncated. To do this:

  1. Right click the Database
  2. Click Tasks -> Export Data
  3. Select your Data Source (defaults should be fine)
  4. Choose “Flat File Destination” for the Destination type.
  5. Pick a file name for the output.
  6. On the “Specify Table Copy or Query”, choose “Write a query to specify the data to transfer”
  7. Paste in your query

Remaining steps should be self explanatory. This will output the file to text and you can open it in your favorite text editor.

More Related Contents:

  1. How can foreign key constraints be temporarily disabled using T-SQL?
  2. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  3. How to create materialized views in SQL Server?
  4. How can I clear the SQL Server query cache?
  5. How to set a default value for an existing column
  6. Need a datetime column in SQL Server that automatically updates when the record is modified
  7. how to make your data horizontal
  8. How do I find a stored procedure containing ?
  9. Error: TCP Provider: Error code 0x2746. During the Sql setup in linux through terminal
  10. SQL Server: Database stuck in “Restoring” state
  11. How to check if a Constraint exists in Sql server?
  12. Access is denied when attaching a database
  13. Getting an odd error, SQL Server query using `WITH` clause
  14. What does “ORDER BY (SELECT NULL)” mean?
  15. Calling stored procedure using VBA
  16. Split one column into multiple rows
  17. SQL Unique constraint across multiple tables
  18. How to find SQL Server running port?
  19. Changing SQL Server collation to case insensitive from case sensitive?
  20. SQLServer IDENTITY Column with text
  21. Why SQL Server DATETIME type saves time in ticks of 1/300 of a sec?
  22. How to store directory / hierarchy / tree structure in the database?
  23. Cannot bulk load. Operating system error code 5 (Access is denied.)
  24. Which is quicker COALESCE OR ISNULL?
  25. Merge multiple rows into a single row
  26. Does query plan optimizer works well with joined/filtered table-valued functions?
  27. Is there an “IF EXISTS” test for a linked server?
  28. Unique identifier (guid) as primary key in database design
  29. How to extract this specific substring in SQL Server?
  30. SQL Server stored procedure return code oddity

Leave a Comment