Changing the CommandTimeout in SQL Management studio

by

If you are getting a timeout while on the table designer, change the “Transaction time-out after” value under Tools –> Options –> Designers –> Table and Database Designers

This will get rid of this message: “Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.”

enter image description here

More Related Contents:

  1. sql server 2008 management studio not checking the syntax of my query
  2. SQL Server 2008: how do I grant privileges to a username?
  3. sql runs fast in ssms slow in asp.net
  4. Saving changes after table edit in SQL Server Management Studio
  5. How do I make a composite key with SQL Server Management Studio?
  6. Logging ALL Queries on a SQL Server 2008 Express Database?
  7. Incorrect syntax near ”
  8. How to see the values of a table variable at debug time in T-SQL?
  9. How to get export output in “real” CSV format in SQL Server Management Studio?
  10. The backend version is not supported to design database diagrams or tables
  11. Converting Select results into Insert script – SQL Server
  12. How to quickly edit values in table in SQL Server Management Studio?
  13. Restrict varchar() column to specific values?
  14. SELECT max(x) is returning null; how can I make it return 0?
  15. SQL: Two select statements in one query
  16. How to return default value from SQL query
  17. SQL INSERT INTO from multiple tables
  18. How to Execute SQL Query without Displaying results
  19. How to insert a string which contains an “&”
  20. SQL Inner Join On Null Values
  21. PostgreSQL: Full Text Search – How to search partial words?
  22. Is this a good way to model address information in a relational database?
  23. Subtracting Dates in Oracle – Number or Interval Datatype?
  24. Conditional aggregation performance
  25. Retrieve Oracle last inserted IDENTITY
  26. RegEx to Detect SQL Injection
  27. SQL Unpivot multiple columns Data
  28. Concat function is not working – invalid number of arguments
  29. ORACLE After update trigger: solving ORA-04091 mutating table error
  30. Foreign Key Not Populating with Primary Key Values

Leave a Comment