Viewing 15 posts - 3,166 through 3,180 (of 4,820 total)
Thanks for the responses everyone. I did not know about the option within the Notifications tab, which is interesting. I had not yet had a chance...
February 28, 2016 at 10:11 pm
robmiller 59717 (2/25/2016)
I have a rather strange issue going on and need some troubleshooting help. We use a application that is written in Visual Foxpro 9 SP2 and uses...
February 26, 2016 at 8:42 am
I can't help much with C#, but... I am just wondering if the Connection Manager object needs to be "opened" before you try to connect using it. The...
February 25, 2016 at 4:55 pm
Brandie Tarvin (2/25/2016)
sgmunson (2/23/2016)
You might want to try CAST(PortNumber AS smallint)...
This or try to change the INT16 in expression to INT32. But yes, INT in a database comes across as...
February 25, 2016 at 10:40 am
You might want to try CAST(PortNumber AS smallint)...
February 23, 2016 at 4:08 pm
Not sure what data types you can cast to, but a 4 digit port number still fits easily into a 16-bit integer, as the range of values for an unsigned...
February 23, 2016 at 4:07 pm
Okay, that takes out execution context differences. How about a corporate firewall issue with connectivity? Have you ever successfully connected to the server in question? ...
February 22, 2016 at 9:57 pm
Jacob, that doesn't surprise me, but I was also thinking that there just might be some conditions that could mess with that query plan, and cause a bad plan and...
February 22, 2016 at 9:54 pm
No problem... I often try to help by asking questions that might provoke a different way of thinking about the problem, ... especially when I don't know the...
February 22, 2016 at 9:49 pm
I don't suppose you could set the COMPAT level temporarily down to the value for SQL 2012 or SQL 2008, and then backup the data, restore it to an available...
February 22, 2016 at 4:06 pm
Why do you need that information? Sometimes, just thinking about the why can provide the impetus for developing an alternative.
February 22, 2016 at 4:04 pm
Your code has to actually execute the count in your first query, and since you are only testing to see if it is greater than 0, there is no need...
February 22, 2016 at 3:53 pm
How are you authenticating to the remote site that the connection points to? The answer might help you see what's going on, as an SSIS package, when run...
February 22, 2016 at 3:36 pm
I think you have the right idea there... an EXECUTE SQL TASK could pretty much take care of the whole shootin' match, so to speak, assuming that the data...
February 13, 2016 at 10:16 am
SQL-DBA-01 (2/12/2016)
Does not say anything bossy!! Checked via Job activity monitor tool too. No luck.
I don't know what you mean by saying "Does not say anything bossy!!"... care to...
February 12, 2016 at 2:44 pm
Viewing 15 posts - 3,166 through 3,180 (of 4,820 total)