Post reply

In which location the SQL Server objects are stored

  • April 27, 2009 at 1:25 am

    #155610

    Dear All,

    I have created tables and using tables i am written Procedure,view and function in Sql Server 2000 database.

    Could you please guide me it is store in which location\path of the the SQL Server 2000.

    Thanks in advance.

    Regards

    Sumanta Panda

  • April 27, 2009 at 1:56 am

    #984207

    Tables, views, functions and procedures are all stored within the database file, hence there's no path to them. Or are you looking for the location of the SQL database files themselves?

    In future please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 27, 2009 at 3:43 am

    #984233

    Yes i am looking for the location of the SQL database files themselves.

    Thanks!!!

    Regards

    Sumanta Panda

  • April 27, 2009 at 4:10 am

    #984242

    This query, when run in the context of the DB in question, will show you where all the files associated with that database are.

    select name, filename from sysfiles

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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