NEWSEQUENTIALID() defect in SSMS. Wasn’t it fixed already in SQL 2012 RTM?

I have recently received this question from different sources, so I think it’s worth documenting why some people still see validation error for the default value of a column when it’s defined as a NEWSEQUENTIALID() built-in. The tracking defect on Connect (https://connect.microsoft.com/SQLServer/feedback/details/472092/newsequentialid-bug-in-management-studio) keeps receiving complains about the observed, undesired behavior. It’s been fixed in Denali…

0

"SQL Execution Error: Timeout expired. The timeout period elapsed…" while opening view from SSMS

Another recently answered question from a colleague. My colleague posted the following question (modified a bit to leave relevant information only): From: <Removed_Intentionally> Sent: <Removed_Intentionally> To: <Removed_Intentionally> Subject: SSMS -> Open View timeout – Help Hi guys Sorry for the Wide Distrib but I wanted the feedback from the Dev guys also , I have…

3

You cannot alter one table using Visual Database Tools (VDT) unless you are either a member of db_dbowner or sysadmin

Members of db_ddladmin fixed database role or users who have explicitly been granted CREATE TABLE permissions cannot alter the table using VDT. If you are connected to an instance of Yukon with a login whose mapped user in a given database is either a member of the db_ddladmin or has been explicitly granted ALTER TABLE…

1