<div>
I think you'll have to post a small piece of the script for us to look at
</div>


<div>
The script is enourmous so attached is just a snippet of the top of the script.<br />
<br />
The first few errors recieved are as follows:<br />
<br />
Msg 208, Level 16, State 1, Line 2<br />
Invalid object name 'sys.foreign_keys'.<br />
Msg 208, Level 16, State 1, Line 2<br />
Invalid object name 'sys.foreign_keys'.<br />
Msg 208, Level 16, State 1, Line 2<br />
Invalid object name 'sys.foreign_keys'.<br />
<br />
Thanks for your help.<br />

<pre><code class="code-10 nolinks" id="code-263421"><span>/****** Object:  ForeignKey [FK__aspnet_Me__Appli__408F9238]    Script Date: 02/22/2009 17:04:27 ******/</span>
<span>IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__408F9238]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))</span>
<span>ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__408F9238]</span>
<span>GO</span>
<span>/****** Object:  ForeignKey [FK__aspnet_Me__UserI__4183B671]    Script Date: 02/22/2009 17:04:27 ******/</span>
<span>IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__UserI__4183B671]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]'))</span>
<span>ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__4183B671]</span>
<span>GO</span>
<span>/****** Object:  ForeignKey [FK__aspnet_Pa__Appli__7226EDCC]    Script Date: 02/22/2009 17:04:27 ******/</span>
<span>IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pa__Appli__7226EDCC]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]'))</span>
<span>ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__7226EDCC]</span>
<span>GO</span>
</code></pre>
</div>


<div>
This seems like a silly question, but are you sure you installed SQL 2005 (and not SQL 2000)?
</div>


<div>
I think so. This is copyied off the about....<br />
<br />
Microsoft SQL Server Management Studio Express &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9.00.2047.00<br />
Microsoft Data Access Components (MDAC) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2000.085.1132.00 (xpsp.080413-0852)<br />
Microsoft MSXML &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2.6 3.0 4.0 5.0 6.0 <br />
Microsoft Internet Explorer &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;6.0.2900.5512<br />
Microsoft .NET Framework &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2.0.50727.3053<br />
Operating System &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5.1.2600
</div>


<div>
That's just about the Management Studio.... not the SQL Engine itself<br />
From the SQL Server Configuration Server, click on the SQL service, Properties, Advanced, and see if the File Version is 2005.90.xxxxx<br />

</div>


<div>
I have ran the query:<br />
<br />
SELECT &nbsp;SERVERPROPERTY('productver<wbr />sion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')<br />
<br />
Which returned:<br />
<br />
Product Version: 8.00.760<br />
<br />
Product Level: SP3<br />
<br />
Edition: Desktop Engine<br />
<br />
According to <a href="http://berezniker.com/content/pages/sql/microsoft-sql-server/sql-server-versions" rel="ugc">http://berezniker.com/content/pages/sql/microsoft-sql-server/sql-server-versions</a>&nbsp;this confirms I have SQL Server 2000 installed.<br />
<br />
Can you advice as to what I need to download and install to upgrade to SQL Server 2005 and perhaps suggest some links where I can get whats needed?<br />
<br />
Many thanks. 
</div>


<div>
Quite frankly, I'd recommend you start over completely, and install the latest SQL Server 2008 Express. &nbsp; It is backwards compatible with 2005 and 200 and will even allow you to migrate a database by merely perform a &quot;detach&quot; operation on the old server and an &quot;attach&quot; operation on the new server (with a few caveats)<br />
Here is the link... I'd suggest you download the version that includes the &quot;with Advanced Services&quot;... as it includes the Management Studio and Reporting Services<br />
<a href="http://www.microsoft.com/express/sql/download/" rel="ugc">http://www.microsoft.com/express/sql/download/</a>&nbsp;<br />
&nbsp;<br />
&nbsp;<br />

</div>


<div>
Can you provide some error logs for &quot;Incorrect syntax near&quot; so that I can look into it.
</div>


<div>
It turns out Sql server 200 was installed. I have since installed 2005 and the script ran correctly.<br />
<br />
thanks for your help
</div>


<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Just a quick overview, I have recently had to reinstall windows on my machine becuase of an unrelated matter so before I did so i created an SQL script using the SQL Server Database Publishing Wizard so that my SQL database could be recreated exaclty as it was.<br />
<br />
I have just reistalled SQL Server 2005 and the Managment Studio and have attempted to run the script.<br />
<br />
Once the script is run there are literally thousands of the following two errors:<br />
<br />
Invalid object name<br />
<br />
and<br />
<br />
Incorrect syntax near ...<br />
<br />
It is just these two varieties of error that appear.<br />
<br />
This is very odd as the script works perfectly on my remote SQL 2005 database server as the database was created exactly. So there clearly isent a problem with the script it must be something to do with the clean install on SQL Server 2005.<br />
<br />
I am unsure why this error is appearing? Has anyone one else had this problem or know a quick fix? <br />
<br />
Can anyone advise?<br />
<br />
Many thanks. 
</div>
</div>


Hi All,

Just a quick overview, I have recently had to reinstall windows on my machine becuase of an unrelated matter so before I did so i created an SQL script using the SQL Server Database Publishing Wizard so that my SQL database could be recreated exaclty as it was.

I have just reistalled SQL Server 2005 and the Managment Studio and have attempted to run the script.

Once the script is run there are literally thousands of the following two errors:

Invalid object name

and

Incorrect syntax near ...

It is just these two varieties of error that appear.

This is very odd as the script works perfectly on my remote SQL 2005 database server as the database was created exactly. So there clearly isent a problem with the script it must be something to do with the clean install on SQL Server 2005.

I am unsure why this error is appearing? Has anyone one else had this problem or know a quick fix? 

Can anyone advise?

Many thanks. 

SQL Server 2005 error:  &quot;Invalid object name&quot; / &quot;Incorrect syntax near&quot;

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

SQL Server 2005 error: &quot;Invalid object name&quot; / &quot;Incorrect syntax near&quot;

SQL Server 2005 error: "Invalid object name" / "Incorrect syntax near"