Viewing 15 posts - 3,196 through 3,210 (of 9,725 total)
After several attempts of resolving the "security issue," I pulled the package and config file down to my desktop. When I loaded the package into my solution, BIDS complained about...
May 2, 2014 at 9:05 am
Oh, my. I think I found the problem. Will post in a moment if I'm right.
May 2, 2014 at 8:15 am
I remoted into the app server (not web server, I keep saying that wrong) with the login in question. I logged into SSMS using windows authentication and opened up the...
May 2, 2014 at 7:54 am
Did you verify your linked server permissions on the secondary database server to make sure it can actually access the database / table and write to it?
EDIT: And are you...
May 2, 2014 at 7:13 am
Royce Blanks (5/1/2014)
...
thanks if you reply. wouldnt be surprised if after all these years you have moved on and are no...
May 1, 2014 at 11:24 am
Darnit. Still getting the same pictogram thing.
April 30, 2014 at 5:51 am
Oh good grief. I'm going to go bury my head in the sand now...
Thanks, David.
April 30, 2014 at 5:45 am
I have tried a couple of different versions of this and keep coming up with "ReadToEnd is not a member of System.IO.Stream". Google can't seem to find anything with that...
April 30, 2014 at 5:15 am
David Burrows (4/28/2014)
Brandie Tarvin (4/28/2014)
Anyone know what this...
April 28, 2014 at 12:26 pm
As I continue troubleshooting this I keep finding interesting things. Now I'm getting a message box back with this response (see attached picture).
Anyone know what this means?
April 28, 2014 at 9:34 am
Brandie Tarvin (4/25/2014)
A WebException has been caught.System.UriFormatException: Invalid URI: The URI scheme is not valid.
at System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind...
April 28, 2014 at 7:21 am
ty 54262 (4/28/2014)
this command with the repair switch and then the repair allow data loss worked perfectly.
Ouch. You should be leery of ever using the "allow data loss" switch with...
April 28, 2014 at 4:39 am
Jeff Moden (4/25/2014)
Brandie Tarvin (4/25/2014)
--You only need one DECLARE statement
-- and you can assign the values within that statement too.
[font="Arial Black"]-- Saves on typing[/font]
"Sure you are? Dark Side...
April 28, 2014 at 4:22 am
RazorbackDBA (4/25/2014)
April 28, 2014 at 4:19 am
homebrew01 (4/25/2014)
Wouldn't the LEFT OUTER JOIN only work for new records, not changed records ?
Depends on what WHERE clause filters you use. I've done it before where I join on...
April 28, 2014 at 4:18 am
Viewing 15 posts - 3,196 through 3,210 (of 9,725 total)