is it possible in SQL 2005 server to save queries files or structure like tables folder wherein my queries from different tables will be save for my future access with my program?, like for example in MSAccess wherein there's a table categories and also with Queries based from tables..wherein I could directly use my query files to save my data or retrieve it, as what is being structured or link in my queries from different tables.

any help from you guys can help me a lot..i'm new to sql server 2005 database set-up..

Thanks
Ben

Thanks

Is that you are looking for the place where the tables and queries are stored in the sql server 2005 database? Not sure if I am getting your question right.

_________________________
- Vijay G
Strive for Perfection

yes happygv that is what I mean...the tables and queries where its resides at sql server 2005...

Queries in Access are called Views in SQL server 2005 that resides in system table "SysComments"
Tables reside in system table "SysObjects"
Column definitions are recorded in system table "SysColumns"

Hope that helps.

_________________________
- Vijay G
Strive for Perfection