Viewing 15 posts - 2,431 through 2,445 (of 2,857 total)
It could be SQL server version related, but if you are running it from your local machine, it shouldn't much matter from my experience. I had an SSIS 2016 package...
June 28, 2017 at 2:12 pm
Looking at the error and the naming of things in there, I'm guessing you are missing sharepoint connectors on your system.
The reason I think this:
1 - you...
June 28, 2017 at 1:40 pm
As a thought, did you change the compatability of the database after upgrading?
I tried looking up that SP on bing hoping to find something related to it (which...
June 28, 2017 at 1:29 pm
Jeff Moden - Wednesday, June 28, 2017 6:55 AMHeh... what's the last cursor you wrote and what did it do?
I am...
June 28, 2017 at 12:57 pm
I agree with Sue on this one (which is usually the case); report subscriptions are stored in the database not the report. Storing them in the report would require having...
June 27, 2017 at 8:27 am
Glad we could help (although I think the majority of the thanks goes to Gail on this one). She asked for all of the information AND she found it being...
June 26, 2017 at 4:10 pm
Quick eyeballing of that, to me it looks like it is more likely:
June 26, 2017 at 3:50 pm
I am assuming based on the names that:
dummy_CustNameXRef_Delete
gets called on delete and:
ADG_CustNameXRef_Add
gets called on insert?
Also, unless I am reading those SP's incorrectly (which...
June 26, 2017 at 3:32 pm
You said you posted 2 triggers, but those are procedures.
Do the triggers call those procedures?
June 26, 2017 at 3:16 pm
I personally wouldn't recommend adding the name to the hosts file. Your DNS should handle that no problem.
As for changing the IP that SQL listens on, I'm not sure...
June 26, 2017 at 11:09 am
That screenshot is a little hard to read, but if I am reading it correctly, you are using SQL 11 (ie 2012).
What is the error right below the one...
June 26, 2017 at 10:56 am
I have seen this happen if I am impatient too. Sometimes when I load up a data source, everything starts out greyed out and if I wait about 20-30 seconds...
June 22, 2017 at 11:35 am
June 22, 2017 at 11:31 am
Another thing to look at would be filtering those results. Is a report with 100K to 500K rows actually useful in any manner? I am not asking if the data...
June 22, 2017 at 11:17 am
June 22, 2017 at 10:45 am
Viewing 15 posts - 2,431 through 2,445 (of 2,857 total)