{"action":"created","issue":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/3950","labels_url":"https://api.github.com/repos/sequelize/sequelize/issues/3950/labels{/name}","comments_url":"https://api.github.com/repos/sequelize/sequelize/issues/3950/comments","events_url":"https://api.github.com/repos/sequelize/sequelize/issues/3950/events","html_url":"https://github.com/sequelize/sequelize/issues/3950","id":88873232,"number":3950,"title":"Transaction name too long for MSSQL","user":{"login":"cdmcnamara","id":1103780,"avatar_url":"https://avatars.githubusercontent.com/u/1103780?v=3","gravatar_id":"","url":"https://api.github.com/users/cdmcnamara","html_url":"https://github.com/cdmcnamara","followers_url":"https://api.github.com/users/cdmcnamara/followers","following_url":"https://api.github.com/users/cdmcnamara/following{/other_user}","gists_url":"https://api.github.com/users/cdmcnamara/gists{/gist_id}","starred_url":"https://api.github.com/users/cdmcnamara/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cdmcnamara/subscriptions","organizations_url":"https://api.github.com/users/cdmcnamara/orgs","repos_url":"https://api.github.com/users/cdmcnamara/repos","events_url":"https://api.github.com/users/cdmcnamara/events{/privacy}","received_events_url":"https://api.github.com/users/cdmcnamara/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/sequelize/sequelize/labels/bug","name":"bug","color":"d7e102"},{"url":"https://api.github.com/repos/sequelize/sequelize/labels/mssql","name":"mssql","color":"bfdadc"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-06-17T00:21:25Z","updated_at":"2015-07-13T13:07:01Z","closed_at":null,"body":"I'm attempting to persist some records within a transaction to a MSSQL database and I'm coming across the following error:\r\n\r\n```\r\nSequelizeDatabaseError: The identifier that starts with '1e340e20-26a3-4881-ac71-1326b01f5af4-savepoint-1' is too long. Maximum length is 32.\r\n```\r\n\r\nThis appears to be because per the MSSQL spec (https://msdn.microsoft.com/en-us/library/ms188929.aspx):\r\n```\r\ntransaction_name\r\nIs the name assigned to the transaction. transaction_name must conform to the rules for identifiers, but identifiers longer than 32 characters are not allowed. Use transaction names only on the outermost pair of nested BEGIN...COMMIT or BEGIN...ROLLBACK statements. transaction_name is always case sensitive, even when the instance of SQL Server is not case sensitive.\r\n```\r\n\r\nThe transaction name originally appears to be a generated uuid but gets the 'savepoint' text appended to it at:\r\nhttps://github.com/sequelize/sequelize/blob/2.0/lib/transaction.js#L23\r\n\r\nI'm not familiar with other character limits on transaction names in databases but the same code works as intended on Postgres.\r\n\r\nI'm using v2.0.0 of Sequelize. Thanks in advance.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sequelize/sequelize/issues/comments/120922174","html_url":"https://github.com/sequelize/sequelize/issues/3950#issuecomment-120922174","issue_url":"https://api.github.com/repos/sequelize/sequelize/issues/3950","id":120922174,"user":{"login":"bboysathish","id":8023447,"avatar_url":"https://avatars.githubusercontent.com/u/8023447?v=3","gravatar_id":"","url":"https://api.github.com/users/bboysathish","html_url":"https://github.com/bboysathish","followers_url":"https://api.github.com/users/bboysathish/followers","following_url":"https://api.github.com/users/bboysathish/following{/other_user}","gists_url":"https://api.github.com/users/bboysathish/gists{/gist_id}","starred_url":"https://api.github.com/users/bboysathish/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bboysathish/subscriptions","organizations_url":"https://api.github.com/users/bboysathish/orgs","repos_url":"https://api.github.com/users/bboysathish/repos","events_url":"https://api.github.com/users/bboysathish/events{/privacy}","received_events_url":"https://api.github.com/users/bboysathish/received_events","type":"User","site_admin":false},"created_at":"2015-07-13T13:07:01Z","updated_at":"2015-07-13T13:07:01Z","body":"@mickhansen Thanks for the update. i dunno what to do, i kind of implemented most of database operation using sequelizejs. is there work around for this. "}}