Does anone know if its possible to use a timer class inside a C# sql procedure method?
the reason i need this if i dont have my data inserted into my DB within 5-10 secs i need to throw an exception.
if i have my method...
public void GetOrders()
// i want to kick off a timer here
// then pull in my data from SAP and put it into DB and if taking more than 10 secs throw an exception
Or if i can throw the exception actually inside the actual SP in the DB?