Viewing 15 posts - 2,206 through 2,220 (of 5,111 total)
March 13, 2018 at 6:10 am
Are you trying to run the report, or preview it (you state "RUN", however, the dialogue says preview, which is confusing)? Generally, with SSRS, you use Preview on a report;...
March 9, 2018 at 8:29 am
Jeff Moden - Wednesday, March 7, 2018 7:48 AMI still want to know why Mr. Britton has 100,000 instances. 😉
Obviously more money...
March 7, 2018 at 7:55 am
I really don't know what you're trying to say here I'm afraid.
You need to (probably) provide some sample data here (Saying my data is "like" this doesn't mean...
March 6, 2018 at 9:35 am
On it's own, error message 31089 doesn't mean a lot. As you're running this in the SSISDB, the logs will tell you far more information. Have a look at these...
February 21, 2018 at 9:19 am
What do you mean my "tried to open"? You don't open a .mdf file, you have to attach it to the Instance. What steps did you take to get the...
February 21, 2018 at 4:28 am
SSIS tasks have to be run using Windows Authentication; they cannot be run by SQL Logins. EXECUTE AS does not even get around this; as that is impersonation it's not...
February 19, 2018 at 10:14 am
February 19, 2018 at 7:08 am
There's no logic to cause that error, that's why. you're setting the value of the error message, but you're not raising one; and your INSERT statement (as far as we...
February 19, 2018 at 3:36 am
Also depends what you're trying to do. Developer edition is for, as the name suggests, development. The licence agreement means you can't use it for any production/live work. If you...
February 19, 2018 at 3:30 am
February 16, 2018 at 9:03 am
Hmm, another interesting tool they've added to SSMS 17.5. SQL Data Discovery and Classification.
Data Discovery & Classification introduces a new tool built into SQL Server...
February 16, 2018 at 3:11 am
I am getting below error
Msg 208, Level 16, State 1,...
February 15, 2018 at 12:28 pm
Little more ugly (well, a lot more), someone might have a better answer, however, this works XML_1_3 logic:
WITH StartEnd AS(
SELECT t.[TYPE], t.BATCH_NO, t.Xml_name,
...
February 15, 2018 at 10:18 am
Actually it is like ID 1 and 2 into 1 xml_name so...
February 15, 2018 at 10:07 am
Viewing 15 posts - 2,206 through 2,220 (of 5,111 total)