Viewing 15 posts - 3,601 through 3,615 (of 5,109 total)
SQL Server 2016 requires SSDT 2016 to be able to deploy SSIS, SSRS, SSAS projects. Unless I'm mistaken, SSDT 2016 is only supported in VS 2015 onwards. I would imagine...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 29, 2017 at 9:26 am
Tables are not ordered to start with. How are you defining your current "order". Alphabetically?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 29, 2017 at 8:58 am
HappyGeek raises a good point here. If you want meaningful answers, you need to provide meaningful sample data. According to your data, 2649 visits all happened at exactly 21:35:37 on...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 29, 2017 at 3:41 am
As a thought, probably a long shot, but I wonder if a column in your database has a different collation to the actual database. Does this yield any results? Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 29, 2017 at 2:52 am
What are you trying to use the variable to do exactly? In SSIS you reference a variable by using the following expression:@[User::YourVariableName]
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 9:09 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 8:27 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 7:30 am
Just as a side note, you can't use SET to set the value of multiple variables. You either need to use SET, and do one at a time, or use...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 6:02 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 4:59 am
Issuing a command of NOCHECK does change the is_not_trusted value for me, however, you could also make double sure my inserting an untrusted record:USE DevTestDB;
GO
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 4:23 am
Just to chime in a little, is SSRS hosted on the same server as the SQL Server engine? If so, how much of the resources is SQL using? Is it...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 4:01 am
Database's don't recognise languages; to them a "female" and "femelle" are just two strings (one 6 characters, one 7). If you need to change the language...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 28, 2017 at 1:51 am
Those are your versions, I asked for Licence type. Do you have Express, Standard, or Enterprise?
If you have Enterprise, you should be able to achieve something with Thom~ Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 27, 2017 at 8:49 am
My apologies - I forgot this one changed a couple of times and is...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 27, 2017 at 8:27 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
June 27, 2017 at 8:21 am
Viewing 15 posts - 3,601 through 3,615 (of 5,109 total)