Hi Kamal,

Jayesh here. I need to know one thing about SQL Server Views.
I want to make a parameterized view in SQL Server 6.5 just like VFP's
local/remote views. Oracle supports this.

For example

CREATE VIEW myview AS SELECT * FROM CUSTOMER
WHERE cid = &vp_cid

Bye
Jayesh


>Hi Michel,
>
>This is the information I got from one of our SQL Server experts:
>
>In a particular database you can run sp_tables which will produce a list of tables and the owner (which I assume is what is meant by who created them). To find the creation date you have to query the sysobjects table. It has a column crdate. So a select name,crdate from sysobjects where type = 'U' will list all user defined tables (as opposed to system tables) in a particular database. If you need anything further let me know. (JosephL@flashcreative.com)
>
>
>>Is there a possibility to have a trigger at the database level on SQL Server 6.5? We would like to have a trigger to store a value whenever we add a new table to the database. Or, is there another mecanism to know that we have added a new table. Like to scan the systable.