Post reply

SQL Server 2000 VIEWS

  • April 22, 2006 at 11:37 pm

    #117049

    Dear Friends,

    I have created a simple view, it is not showing the list of columns when viewed in Query Analyzer. 

    But with sp_help command it is showing the columns list.

    Quick help will be highly appreciated.

     

    Regards,

    Atiq Rahman

  • April 23, 2006 at 12:55 am

    #633674

    Have you tried running "exec sp_refreshview" store proc for this view?

  • April 24, 2006 at 5:44 am

    #633735

    neat; i found out that this is an extended stored procedure when i tried to sp_helptext sp_refreshview.

     

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

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