i have to make helpdesk application for teh IT Department of my company,so if anyone can help by supporting me by database schema for HelpDesk application.
thank you for the help
You can use the Asp.net 2.0 built in profile as one of the tables for a small application and use Trigger with fake time stamp to write to the incident table. The time stamp you need should be fake because the current SQL Server time stamp is a derived data type used by SQL Server. Another option is to use the database, tables and constraints from the ISSUE Tracker starter kit. Try the links below for the fake time stamp trigger and download the Issue tracker starter kit. Hope this helps.
http://forums.asp.net/832746/showpost.aspx
http://www.aspfaq.com/show.asp?id=2448
No comments:
Post a Comment