Viewing 15 posts - 2,776 through 2,790 (of 2,853 total)
I'd change it then to a real user instead of any built-in users.
If it was me, I'd make at least 2 - one for SQL Server and one...
February 13, 2017 at 3:06 pm
February 13, 2017 at 2:56 pm
February 13, 2017 at 2:52 pm
February 13, 2017 at 2:46 pm
BEGIN CATCH
PRINT ERROR_MESSAGE()
ROLLBACK TRANSACTION;
RETURN
END CATCH
This prints the error. But still , this...
February 13, 2017 at 1:52 pm
IF (@CompetitorCode...February 13, 2017 at 1:45 pm
February 13, 2017 at 1:23 pm
February 13, 2017 at 1:05 pm
February 13, 2017 at 12:59 pm
February 13, 2017 at 12:49 pm
We had a simlar thing. You should check the SQL Server logs.
In our case, a 3rd party tool incorrectly force closed a connection before SQL was ready so the...
February 13, 2017 at 10:40 am
There is also some weirdness with your code. Your:SELECT @code
FROM inserted
line is strange. You don't need a FROM when you are just selecting the variable.
February 13, 2017 at 10:26 am
February 13, 2017 at 10:11 am
I had a problem similair to that a while back, one thing i did...
February 10, 2017 at 3:00 pm
Viewing 15 posts - 2,776 through 2,790 (of 2,853 total)