Error Type:<BR>Microsoft OLE DB Provider for SQL Server (0x80040E14)<BR>Maximum stored procedure nesting level exceeded (limit 32).
...Looks like you got a procedure that calls another procedure that loops back around and calls the original procedure.<BR><BR>Better double check your code for recursion that you may not have wanted there.
i managed to figure it out...u were right... anyway, do u know how to get only date instead of date and time?<BR><BR>using trigger...<BR><BR>mydate = getDate()
...use DatePart to construct your date from getDate()
errr what do u mean?
...look it up in the enterprise manager help for the arguments to returning only a specifically formatted date instead of the datetime from GetDate()