works like a charm.....thank you Steve and everyone else.

Hi Reshu,

  Thanks for giving me an example. But using this code, compiles the sproc, but when I try to execute the sproc using the following query:

exec usp_update_emp_data 'emp_details', 'Name=''John'',Age=''34''',...

Hmm....well in that case will I better off writing the UPDATE query in ASP and execurting it using ADODB connection??

Also if possible can you or anyone give me an example...

Dave,

   To most part we will run SELECT queries on the table. But occassionally we will need to run an insert or update on the table.

   Based on the...

>Can a single Person_ID have multiple Place_IDs?

   Unfortunately yes. And the date we got, a single person have same place_IDS (I know bad data entry).

>Can there be multiple instances of a single...

Thank you guys, I really appreciate all your comments and suggestions on my post. I was just wondering if there was a quick and dirty way of doing this, but...

If you can take your server offline for a while, try detach the database  and then attach the database to your production server (using SQL serer Enterprise).

Note:

Don't mess with...

I am posting not as a reply to the actual question, but to find out how I can do the opposite of it.

ie., if a user generates a report...

I guess your are asking if a user have permission to access files stored in MSSQL\Data directory. If so, first I detached the database using Enterprise manager and then I...

Hi guys,

   thank you for your responses. I tried using sp_attach_single_file_db but it doesnot work. When I look into the SQL server logs, it says Device activation Error. Failed to...

I just to have my database tables, so that I can query them using my front end application (ASP). I dont need enterprise manager/query analyzer.

Thanks alot for all the input you guys have provided. This will certainly give me a direction.

With respect to the speed of the application, I guess right now we are...

Thank you Steve. Sounds encouraging. Is there any documentation I can read about to get a head start. I tried search on Micro$oft website, but with no luck so far....

Thank you Steve, can you point me to some examples on triggers. I am kind of newbie in writing trigger/sp's.

thank you for all your help,

v

Thank you for replying racosta. I am looking for a way to find out last time a record was updated in a table.

any thoughts,

thank you,

v