Viewing 15 posts - 3,886 through 3,900 (of 13,855 total)
October 30, 2018 at 2:32 pm
What the heck does the sd stand for in sd.name
sd is aliasing sys.databases
No offence, but if you're a DBA, you should know about table aliases 🙂
October 30, 2018 at 12:49 pm
Can you give us an example of an entire query which fails - something which we can run in isolation?
October 30, 2018 at 11:42 am
October 30, 2018 at 7:45 am
October 30, 2018 at 7:21 am
October 29, 2018 at 11:17 am
Does this version work?BEGIN TRY
DROP TABLE #adr_test;
END TRY
BEGIN CATCH
-- nothing to drop
END CATCH;
CREATE TABLE #adr_test
(
style ...
October 29, 2018 at 10:20 am
Your ScriptResults enum is missing.
Why are you doing this in a script task rather than a stored procedure? This logic belongs in the database.
Try this:
October 29, 2018 at 6:10 am
Why would a vendor mix and match like that?
Incompetence? Lack of care?
I doubt there's a technical reason.
October 26, 2018 at 1:48 pm
October 26, 2018 at 1:36 pm
Yip agree theres much better ways of doing it but hes implemented this...
October 26, 2018 at 12:55 pm
Just figured out it had nothing to do with the SQL upgrade but it does...
October 26, 2018 at 12:54 pm
When I run it on 2017, the numbers are sequential.
What is the point of this code?
And please do not rely on the 'quirky update' unless you...
October 26, 2018 at 12:20 pm
Double-click the constraint line.
October 26, 2018 at 9:20 am
Viewing 15 posts - 3,886 through 3,900 (of 13,855 total)