hey, i have a small bussines with share point and msde2000, when i try to create a table in the servername\sharepoint, i get this DDL statement is not allowed, can anyone help wiht that
thanks
The sharepoint instance is reserved for sharepoint use, you can not perform
DDL operations on it. You can install another instance of MSDE by
downloading it from the web.
--
-Euan
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
"eslalinde" <eslalinde@.discussions.microsoft.com> wrote in message
news:E5133112-0575-4A3D-AC3A-81A21F470194@.microsoft.com...
> hey, i have a small bussines with share point and msde2000, when i try to
create a table in the servername\sharepoint, i get this DDL statement is not
allowed, can anyone help wiht that
> thanks
Showing posts with label point. Show all posts
Showing posts with label point. Show all posts
Wednesday, March 7, 2012
DDL in a Transaction?
Can someone point me to a doc on including DDL in a transaction? I have
never seen this and I need to understand it.
Thanks,
MichaelSnake wrote:
> Can someone point me to a doc on including DDL in a transaction? I
> have never seen this and I need to understand it.
> Thanks,
> Michael
begin tran
create table T12345Test (col1 int not null primary key)
insert into T12345Test Values (1)
insert into T12345Test Values (2)
select * from T12345Test
Rollback
Select * from T12345Test
David Gugick
Quest Software|||Here's a trivial example in which the newly create table is gone after the
rollback.
BEGIN TRAN
CREATE TABLE MyTable(Col1 int)
ROLLBACK
Hope this helps.
Dan Guzman
SQL Server MVP
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:B1FF6942-7C35-44EB-BD03-764DFA0440D0@.microsoft.com...
> Can someone point me to a doc on including DDL in a transaction? I have
> never seen this and I need to understand it.
> Thanks,
> Michael|||why would anyone have the need to create a table on the fly? That
would mean they have no valid data model and are screwed up beyond
belief.
We need more information to repair this disaster.|||There are lots of reasons to do this, just because you've not experienced
those does not make it wrong.
Some reasons...
Knowledge Management system where you dynamically build an object model, we
wrote a system (product), the meta 'model' was stored in a fixed database
design but user tables where created based on the model.
Datawarehousing, Archiving to name another two.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1132195794.207649.327090@.g49g2000cwa.googlegroups.com...
> why would anyone have the need to create a table on the fly? That
> would mean they have no valid data model and are screwed up beyond
> belief.
> We need more information to repair this disaster.
>|||I sometimes include DDL in a transaction as part of physical schema change
scripts as an alternative to backup/restore. Joe's probably never run into
this since he always gets his data model right the first time :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Tony Rogerson" <tonyrogerson@.sqlserverfaq.com> wrote in message
news:OrZLtO16FHA.1020@.TK2MSFTNGP15.phx.gbl...
> There are lots of reasons to do this, just because you've not experienced
> those does not make it wrong.
> Some reasons...
> Knowledge Management system where you dynamically build an object model,
> we wrote a system (product), the meta 'model' was stored in a fixed
> database design but user tables where created based on the model.
> Datawarehousing, Archiving to name another two.
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "--CELKO--" <jcelko212@.earthlink.net> wrote in message
> news:1132195794.207649.327090@.g49g2000cwa.googlegroups.com...
>
never seen this and I need to understand it.
Thanks,
MichaelSnake wrote:
> Can someone point me to a doc on including DDL in a transaction? I
> have never seen this and I need to understand it.
> Thanks,
> Michael
begin tran
create table T12345Test (col1 int not null primary key)
insert into T12345Test Values (1)
insert into T12345Test Values (2)
select * from T12345Test
Rollback
Select * from T12345Test
David Gugick
Quest Software|||Here's a trivial example in which the newly create table is gone after the
rollback.
BEGIN TRAN
CREATE TABLE MyTable(Col1 int)
ROLLBACK
Hope this helps.
Dan Guzman
SQL Server MVP
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:B1FF6942-7C35-44EB-BD03-764DFA0440D0@.microsoft.com...
> Can someone point me to a doc on including DDL in a transaction? I have
> never seen this and I need to understand it.
> Thanks,
> Michael|||why would anyone have the need to create a table on the fly? That
would mean they have no valid data model and are screwed up beyond
belief.
We need more information to repair this disaster.|||There are lots of reasons to do this, just because you've not experienced
those does not make it wrong.
Some reasons...
Knowledge Management system where you dynamically build an object model, we
wrote a system (product), the meta 'model' was stored in a fixed database
design but user tables where created based on the model.
Datawarehousing, Archiving to name another two.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1132195794.207649.327090@.g49g2000cwa.googlegroups.com...
> why would anyone have the need to create a table on the fly? That
> would mean they have no valid data model and are screwed up beyond
> belief.
> We need more information to repair this disaster.
>|||I sometimes include DDL in a transaction as part of physical schema change
scripts as an alternative to backup/restore. Joe's probably never run into
this since he always gets his data model right the first time :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Tony Rogerson" <tonyrogerson@.sqlserverfaq.com> wrote in message
news:OrZLtO16FHA.1020@.TK2MSFTNGP15.phx.gbl...
> There are lots of reasons to do this, just because you've not experienced
> those does not make it wrong.
> Some reasons...
> Knowledge Management system where you dynamically build an object model,
> we wrote a system (product), the meta 'model' was stored in a fixed
> database design but user tables where created based on the model.
> Datawarehousing, Archiving to name another two.
> --
> Tony Rogerson
> SQL Server MVP
> http://sqlserverfaq.com - free video tutorials
>
> "--CELKO--" <jcelko212@.earthlink.net> wrote in message
> news:1132195794.207649.327090@.g49g2000cwa.googlegroups.com...
>
Friday, February 17, 2012
DBMGR2K Download site
Hello!
I've heard about a free tool for msde "dbmgr2k" can someone please help to point me to where can i download the software?
Thanks in advance!
Try this link I am assuming this what you mean. Hope this helps.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en|||Thanks Caddre for the information!
I've seen the tool that im looking for after searching it in google.
It was my mistake that I ommit letter "a". Im searching "dbmgr2k" instead of "dbamgr2k".
thanks again
I've heard about a free tool for msde "dbmgr2k" can someone please help to point me to where can i download the software?
Thanks in advance!
Try this link I am assuming this what you mean. Hope this helps.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en|||Thanks Caddre for the information!
I've seen the tool that im looking for after searching it in google.
It was my mistake that I ommit letter "a". Im searching "dbmgr2k" instead of "dbamgr2k".
thanks again
Subscribe to:
Posts (Atom)