Post reply

Error : SQl server

  • October 8, 2009 at 6:41 am

    #215277

    Hi Expects

    Error:

    Msg 2714, Level 16, State 3, Procedure XXXXX, Line 3

    There is already an object named 'XXXXX' in the database.

    But NO same name for that view

    any problem please share the solution

    thanks for advance ....

  • October 8, 2009 at 6:55 am

    #1063403

    try this:

    select * from sys.objects where name='XXXX'

    The column [type_desc] is telling you what type of object this is

    Wilfred
    The best things in life are the simple things

  • October 8, 2009 at 6:56 am

    #1063404

    There might be a Table or Procedure with that name already in the database

  • October 8, 2009 at 7:01 am

    #1063408

    hi thanks for your reply

    table is same name but i m going to create view only in with same name

    it's showing the error

    plz share any option for avoid this error

  • October 8, 2009 at 7:04 am

    #1063410

    You cannot create view with the same name as a table. You will have to choose a different name ofr the view, or create th eview in a different schema to the original table.

    Mike John

  • October 8, 2009 at 7:10 am

    #1063420

    k thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply