Viewing 15 posts - 8,806 through 8,820 (of 13,882 total)
A brief Google search turned this up.
January 7, 2015 at 4:50 am
Maybe the instance is not running in 'mixed' authentication mode?
January 7, 2015 at 4:38 am
The best way to do this, IMO, is to move processed files/folders to an Archive folder somewhere.
Then your FEL can remain as it is, picking up everything when it runs...
January 7, 2015 at 1:00 am
If something is non-deterministic, then it's very possible for the re-evaluations of the object test to miss all of the WHEN's and produce a NULL if there is no...
January 7, 2015 at 12:52 am
Thanks for posting back and I'm glad it worked out.
January 6, 2015 at 1:15 pm
Sounds like the dev might have hard-coded something into the package which is not being overridden by the config.
I'd spend a few minutes editing the package to see whether you...
January 6, 2015 at 10:42 am
Imagine if the table were normalised. Something like this:
(Id, Mode, StartDate, EndDate)
I think you'd need a query like:
select id
from table
where Mode = 1
except
select id
from table
where
(Mode = 2 and Enddate...
January 6, 2015 at 10:38 am
Have you considered setting the columns to NOT NULL?
(After fixing existing NULLs, of course)
January 6, 2015 at 4:07 am
Just played around with this a bit and it seems that the CHOOSE function does not deal well using functions directly in the 'index' argument.
This is not just a consequence...
January 6, 2015 at 3:25 am
batgirl (1/5/2015)
1. Downgrading my "job" - this is my last week of a full time high pressure job (on call 24 x 7) and...
January 5, 2015 at 11:48 am
Ah, now I understand.
Go to Tools/Options in SSMS. Select SQL Server Object Explorer / Scripting.
Set 'Check for object existence' to False.
January 5, 2015 at 7:35 am
'Scripting' is how stored procedures are modified – it is the only way.
January 5, 2015 at 7:33 am
m_swetz (1/4/2015)
January 5, 2015 at 12:50 am
You cannot configure the connection directly like that.
Please read through this [/url]article and see whether it helps you.
January 5, 2015 at 12:29 am
Viewing 15 posts - 8,806 through 8,820 (of 13,882 total)