create table RRS feed

  • Question

  • Hi everyone,
    I'm new at this, I'm trying to create a table following the sample from a book called "Begining SQL server 2008 express for developers: from Novice to Professional"
    any help would be greatly appreciated.
    This is the error I get: 

    Msg 2760, Level 16, State 1, Line 1

    The specified schema name "TransactionDetails" either does not exist or you do not have permission to use it.

    CREATE TABLE TransactionDetails.Transactions
        (TransactionId bigint IDENTITY(1,1) NOT NULL,
        CustomerId bigint NOT NULL,
        TransactionType int NOT NULL,
        DateEntered datetime NOT NULL,
        Amount numeric(18, 5) NOT NULL,
        ReferenceDetails nvarchar(50) NULL,
        Notes nvarchar(max) NULL,
        RelatedShareId bigint NULL,
        RelatedProductId bigint NOT NULL)
    Thursday, September 15, 2011 7:46 PM


All replies