View Single Post
  #5 (permalink)  
Old April 8th, 2010, 05:34 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts

Hi there,

Excellent instructions and walkthrough. I was able to get in and reproduce the problem in minutes.

Here's the error I am getting:

Invalid object name 'sys.foreign_keys'.

This seems to suggest the server is running an older version of SQL Server: SQL Server 2000. The scripts created by Visual Studio are compatible with 2005 and 2008 only.

So, I think you need you need to confirm with your host if a) they are indeed using SQL Server 2000 and b) if they have 2005 / 2008 as an option for you as well.

For more info, and people with similar problems:

You may be able to use the tip described in the first link to generate 2000 compatible scripts, but I think you'll run into other compatibility issues (data types that don't exist in 2000 for example).


Imar Spaanjaars
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
The Following User Says Thank You to Imar For This Useful Post:
jack_hilary (April 9th, 2010)