Viewing 15 posts - 886 through 900 (of 49,571 total)
August 18, 2017 at 1:51 am
August 18, 2017 at 1:35 am
What are you trying to do?
NewID returns unique guids, different one every time it's called.
August 18, 2017 at 1:16 am
Formatted so that it's actually readable.
ALTER FUNCTION fn_PayrollConfirm (@EmpID INT)
RETURNS @PayrollConfirm TABLE (
PayslipID INT IDENTITY(1, 1),
EmpID INT,
...
August 18, 2017 at 1:15 am
August 17, 2017 at 12:10 pm
August 17, 2017 at 12:01 pm
Phil Parkin - Thursday, August 17, 2017 11:35 AMCould it be this?
Very likely.
Essentially, SQL has a cache of identity values,...
August 17, 2017 at 11:52 am
August 17, 2017 at 11:45 am
Yes. Data was lost.
Repairing, especially with allow_data_loss, is a last resort for when there's no other way of fixing things. Best method is to restore from a clean...
August 17, 2017 at 10:08 am
Why is that a problem?
And no, 'a comfortable value is apparently 24 / 4 * 300 = 1800 seconds or 30 minutes', is not a comfortable level,...
August 17, 2017 at 10:05 am
August 17, 2017 at 1:00 am
August 16, 2017 at 11:09 pm
August 16, 2017 at 12:04 pm
Viewing 15 posts - 886 through 900 (of 49,571 total)