Vit007 on Wed, 23 May 2012 06:09:07
migrating from a local database
on the Azure.
Advise how best to replace the Azure:
ALTER TABLE [dbo]. [Table1] ADD DEFAULT (host_name ()) FOR [User123]
Arwind - MSFT on Wed, 23 May 2012 08:29:46
After test in SQL Azure, it says:
Built-in function 'host_name' is not supported in this version of SQL Server.
It seems host_name function is not supported in current version of SQL Azure, but you can try to change host_name() to specific value instead, such as:
ALTER TABLE [dbo]. [Table1] Add DEFAULT ('MySQLHostName') FOR [User123]
Hope this helps.