Jon, are you permitted to create/amend stored procedures? What about tables?
Why does the code have to be run twice per second when the returned values will change little in that time?
SQL is being feed data remotely from a financial charting package, the data sent to SQL is totals, they will change every 500ms, SQL is being used as push into and the draw put of across different programs, the data is then analysis with price movement, so 500ms if fair, even a small change in data will have results as I work in frequency analysis so, so time and price are linked, I must have equal time bins to work, that is why I keep drawing off the data.
How can I check that I am permitted to create and amend tables? I thought my login was setup as admin so i dont have any restrictions.
Jon