Storing sql server data in a stored procedure setting datetime value by getdate() however, it doesn't seem to be storing seconds. Too many transactions within the same minute. Anyway to get a more precise datetime value in a stored procedure other than getdate()? We were passing the datetime from VFP but with many workstations the time could be wrong on each (that will change and the datetime will come from a server in the future) but for now, I need to store the current datetime (including seconds) to a variable in a stored procedure which then stores it to a record. When we look later at the data, all of the minutes are the same on many records so the order by clause on the datetime column is not precise enough.

On my test system, it stores with the precision sqlserver states it should have. But on the live system, not. All minutes are rounded .