Re: [dev] OTRS on SQL Azure: Question regarding DB Scripts

2014-04-03 Thread Sean Killeen
Martin, Regarding your closing of the bug report as a feature request, I'm not sure it necessarily has to be that way. It is only a small subset of T-SQL Commands that are not supported in SQL Azure. The list: http://msdn.microsoft.com/library/azure/ee336250.aspx The elements that are not

Re: [dev] OTRS on SQL Azure: Question regarding DB Scripts

2014-04-03 Thread Michiel Beijen
Hi, I saw a requirement for having indexes on all tables for replication before; also as a need for replication, but on a different database than SQL Server. For Sean it would be possible to add indexes of identity columns to these tables (caveat: untested) ALTER TABLE [yourTable] ADD MyID INT

Re: [dev] OTRS on SQL Azure: Question regarding DB Scripts

2014-04-03 Thread Sean Killeen
@Mike, thanks for the additional interest! I understand that some of these tables may have no need for primary keys at all. In this case, would it make the most sense to create just a clustered index that included all columns (without adding a PK constraint?) This would serve SQL server by