Viewing 10 posts - 1 through 10 (of 10 total)
I think sys.configuration is mess up something with this shutdown on the sever is it possible ?
April 26, 2018 at 4:09 am
Yes server was shutdown not expected
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2...
April 26, 2018 at 4:08 am
Nothing in error log specifically. I have job with t-sql script to run every moring to backup db, Check script
DECLARE @path VARCHAR(500)
DECLARE @name VARCHAR(500)
DECLARE...
April 26, 2018 at 2:26 am
Founded solution
CREATE TABLE #TempTable(
UserID int,
Withdrw int
)
INSERT INTO #TempTable(UserID,Withdrw)
SELECT UID,
COUNT(AS_TYP) AS AS_tYP
FROM AccountStatement
WHERE AS_TYP = 2
GROUP BY UID
HAVING COUNT(AS_TYP) >=...
March 25, 2018 at 11:46 am
Yea, Thanks.I'll test now with this script, but why this cursor dont work 🙁
March 21, 2018 at 6:31 am
Thanks alot guys !! 🙂
October 27, 2017 at 1:42 am
Actually i take 50 rows in batch and when i see reference rollback but script dosnt stop move forward take another 50 and again and again, for now from 1.5...
September 20, 2017 at 5:20 am
I get it man i didnt see it because i hit some rows where have reference to another table.So the statement has been terminated, but the rows is delete it...
September 20, 2017 at 4:00 am
This script delete data , but when finish message is Query Completed with errors., i think the problem is in this logic
The problem is i need to insert...
September 20, 2017 at 3:07 am
Viewing 10 posts - 1 through 10 (of 10 total)