Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
davef101
Starting Member
5 Posts |
 Posted - 2008-02-08 : 04:46:40
|
| An error occured: System.Data.SqlClient.SqlException: Invalid object name 'sys.foreign_keys'.I'm getting the above error when trying to excute the SQL script generated by VS2005.First lines of SQL Script:/****** Object: ForeignKey [FK_CarEngineSize_CarManufacturers] Script Date: 02/08/2008 09:22:56 ******/IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_CarEngineSize_CarManufacturers]') AND parent_object_id = OBJECT_ID(N'[dbo].[CarEngineSize]'))ALTER TABLE [dbo].[CarEngineSize] DROP CONSTRAINT [FK_CarEngineSize_CarManufacturers]GO/****** Object: ForeignKey [FK_CarEngineSize_CarModels] Script Date: 02/08/2008 09:22:56 ******/IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_CarEngineSize_CarModels]') AND parent_object_id = OBJECT_ID(N'[dbo].[CarEngineSize]'))ALTER TABLE [dbo].[CarEngineSize] DROP CONSTRAINT [FK_CarEngineSize_CarModels]GO/****** Object: ForeignKey [FK_CarModels_CarManufacturers] Script Date: 02/08/2008 09:22:56 ******/IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_CarModels_CarManufacturers]') AND parent_object_id = OBJECT_ID(N'[dbo].[CarModels]'))ALTER TABLE [dbo].[CarModels] DROP CONSTRAINT [FK_CarModels_CarManufacturers]GOPlease help!? :) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-08 : 04:53:28
|
| I didnt get any error when i tried executing this.Where are you executing this from? |
 |
|
|
davef101
Starting Member
5 Posts |
Posted - 2008-02-08 : 04:55:15
|
| I'm Trying to excute this at the server end via an aspx page |
|
|
|
|
|
|
Help with creating Db with T-SQL Script