ddl statement is not allowed
in [Server Configuration]
|
From: rob.graveley on 6 Sep 2006 06:47 Can someone help me with this. I have installed the trail version of SQL Server 2005 on a 2003 server box alongside an existing installation of SQL Server 2000. I can connect to and create new databases but cannot create tables within the database with create table statements. I get the error 'DDL statement is not allowed'. MDAC is at version 2.82.1830.0 I have used the same installation executable to install the same trail version of SQL server 2005 on a different XP box with no previous SQL Server 2000 instance on it and everything works fine there. I have searched high and low for meaningful information on what may be causing this and how to fix it but with no success. Anyone have any hints, tips, ideas and best of all a solution. Thanks in advance Rob
From: Tibor Karaszi on 6 Sep 2006 06:54 I would guess that you have a DDL trigger that prohibits this. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ <rob.graveley(a)tribalgroup.co.uk> wrote in message news:1157539667.114946.82400(a)m79g2000cwm.googlegroups.com... > Can someone help me with this. > > I have installed the trail version of SQL Server 2005 on a 2003 server > box alongside an existing installation of SQL Server 2000. I can > connect to and create new databases but cannot create tables within the > database with create table statements. I get the error 'DDL statement > is not allowed'. MDAC is at version 2.82.1830.0 > > I have used the same installation executable to install the same trail > version of SQL server 2005 on a different XP box with no previous SQL > Server 2000 instance on it and everything works fine there. > > I have searched high and low for meaningful information on what may be > causing this and how to fix it but with no success. Anyone have any > hints, tips, ideas and best of all a solution. > > Thanks in advance > > Rob >
From: rob.graveley on 6 Sep 2006 07:05 Aye, that's what I thought too but there are no database level triggers and no system level triggers. Select * from sys.triggers returns no records Rob Tibor Karaszi wrote: > I would guess that you have a DDL trigger that prohibits this. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://www.solidqualitylearning.com/ > > > <rob.graveley(a)tribalgroup.co.uk> wrote in message > news:1157539667.114946.82400(a)m79g2000cwm.googlegroups.com... > > Can someone help me with this. > > > > I have installed the trail version of SQL Server 2005 on a 2003 server > > box alongside an existing installation of SQL Server 2000. I can > > connect to and create new databases but cannot create tables within the > > database with create table statements. I get the error 'DDL statement > > is not allowed'. MDAC is at version 2.82.1830.0 > > > > I have used the same installation executable to install the same trail > > version of SQL server 2005 on a different XP box with no previous SQL > > Server 2000 instance on it and everything works fine there. > > > > I have searched high and low for meaningful information on what may be > > causing this and how to fix it but with no success. Anyone have any > > hints, tips, ideas and best of all a solution. > > > > Thanks in advance > > > > Rob > >
From: Tracy McKibben on 6 Sep 2006 08:13 rob.graveley(a)tribalgroup.co.uk wrote: > Can someone help me with this. > > I have installed the trail version of SQL Server 2005 on a 2003 server > box alongside an existing installation of SQL Server 2000. I can > connect to and create new databases but cannot create tables within the > database with create table statements. I get the error 'DDL statement > is not allowed'. MDAC is at version 2.82.1830.0 > > I have used the same installation executable to install the same trail > version of SQL server 2005 on a different XP box with no previous SQL > Server 2000 instance on it and everything works fine there. > > I have searched high and low for meaningful information on what may be > causing this and how to fix it but with no success. Anyone have any > hints, tips, ideas and best of all a solution. > > Thanks in advance > > Rob > Are you sure you're connecting to the SQL 2005 instance? -- Tracy McKibben MCDBA http://www.realsqlguy.com
From: rob.graveley on 6 Sep 2006 08:44
Yes, absolutely. From SQL Server Management Studio I have the option of connecting to the database engine of <my_server_name> or <my_server_nqme>\MICROSOFT##SSEE The later is the SQL Server 2005 instance and that is the instance I am connecting to. Rob Tracy McKibben wrote: > rob.graveley(a)tribalgroup.co.uk wrote: > > Can someone help me with this. > > > > I have installed the trail version of SQL Server 2005 on a 2003 server > > box alongside an existing installation of SQL Server 2000. I can > > connect to and create new databases but cannot create tables within the > > database with create table statements. I get the error 'DDL statement > > is not allowed'. MDAC is at version 2.82.1830.0 > > > > I have used the same installation executable to install the same trail > > version of SQL server 2005 on a different XP box with no previous SQL > > Server 2000 instance on it and everything works fine there. > > > > I have searched high and low for meaningful information on what may be > > causing this and how to fix it but with no success. Anyone have any > > hints, tips, ideas and best of all a solution. > > > > Thanks in advance > > > > Rob > > > > Are you sure you're connecting to the SQL 2005 instance? > > > -- > Tracy McKibben > MCDBA > http://www.realsqlguy.com |