We're migrating Web & Classic shared hosting customers using MS SQL databases to a newer version MS SQL — 2012. This can impact your account in two ways:
If you connect to your database through an IP address, which we don't recommend, it will no longer work when your database is moved to MS SQL 2012.
Instead, we recommend using your database's host name, which you can find using Viewing Your Database Details with Shared Hosting Accounts.
Note: Your database's hostname is not changing.
MS SQL no longer supports the following features:
|Database objects||Recreate the trigger without |
|Query hints||Use |
|Transact-SQL||Rewrite the statement using the current |
|Transact-SQL syntax||Use |
|Transact-SQL syntax||Use ANSI join syntax|
|Impacted feature you use||Next step|
|None||No action necessary|
|Using your database's IP address||Start using its hostname|
|Discontinued MS SQL features||Amend your code using the guidance in this article|