Viewing 15 posts - 1,426 through 1,440 (of 5,109 total)
Some parts of the ANSI-89 joins aren't deprecated/unsupported no, but others are (you can't use the LEFT JOIN syntax anymore, for example) Does it make sense to rewrite them? Yes,...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 11:54 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 10:08 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 10:05 am
If you're using Visual Studio 2010, that implies you were using SSDT 2012; which I don't think there was a free version of. SQl Server Developer edition was free from...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 9:58 am
I can't see how ISNULL would work here. ISNULL returns the second expression if the first expression has a value of NULL. Considering that the expression you want to return...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 9:53 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 9:48 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 9:34 am
Profile has been deprecated for some time now. Why not use an Extended Event and add a filter on the database name; setting the value to said database.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 9:02 am
If you have a object with which is classified as sensitive, then that value will not be decrypted unless you have the right credential; password, userkey, etc. If you open...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 19, 2018 at 8:09 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2018 at 3:08 pm
It seems you forgot to include the most important part: the actual T-SQL you used. ??
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2018 at 11:58 am
Duplicate of https://www.sqlservercentral.com/Forums/2010375/Connect-Adventureworks-DB-to-Visual-Studio-2012. Please direct answers there (and please don't create multiple threads for the same problem, it actually makes it harder for people to answer; for example you...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 17, 2018 at 5:59 am
Stuck with a query (first post, quite a beginner, but a complex query (i...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 15, 2018 at 9:04 am
You can back up and restore an SSISDB, yes. Did you restore the key as well? You say the packages don't run, what errors did you get?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 15, 2018 at 4:59 am
makis_best - Thursday, November 15, 2018 12:30 AMThank you all for the help....
Working fine now...
Did you fix the injection issue then by...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 15, 2018 at 2:12 am
Viewing 15 posts - 1,426 through 1,440 (of 5,109 total)