Question

Vit007 on Wed, 23 May 2012 06:09:07


Hi.

I am 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]



Sponsored



Replies

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.