Viewing 15 posts - 1,606 through 1,620 (of 4,272 total)
In your environment is there a process to challenge a requirement? I have experienced many cases where the business makes a technical requirement without being able to justify or...
February 16, 2011 at 12:50 pm
Sorry I haven't been able to respond.
A table config is very similar to the config of a file config in how it is setup in the package. Unless you...
February 16, 2011 at 12:36 pm
Completely agree with G on the job, calling one from a sproc is more complex and requires either using xp_cmdshell which I don't usually allow or starting the pre-defined job,...
February 15, 2011 at 9:45 am
I would have to ask about the underlying process, please help me understand why you want to do this. A bulk insert would be way more efficient.
CEWII
February 15, 2011 at 9:17 am
I will admit up front that I would rarely suggest db mirroring. One of my biggest issues is that for reliability SQL has to do a two-phase commit, meaning...
February 10, 2011 at 10:28 am
Given that mainstream support for SQL 2000 ended 04/08/2008, I don't think you will find any.
I can't think of any reason a vendor would want to offer this, there is...
February 9, 2011 at 3:39 pm
The question really isn't can you do this, but what are you trying to accomplish? high availability? zero-data loss? Minimal data-loss?
Clustering is there for high availability but does...
February 9, 2011 at 3:30 pm
Perfect, Thanks. I figured it was something stupid.. I just couldn't find an example to point me in the right direction..
CEWII
February 9, 2011 at 2:52 pm
Only if the database is unavailable or offline, you can set the option for that. But you only have the choice of all or select which ones, there is...
February 9, 2011 at 2:31 pm
No problem, setup a non-default profile and specify it for this process when you call the sproc. you can have multiple profiles to handle different reply-to's and such..
CEWII
February 9, 2011 at 2:01 pm
I fully agree with Grant and GSquared. With the nominal price of about $50 you have a full SQL server with ALL the features to develop and test on....
February 9, 2011 at 1:59 pm
I'd question WHY you want to do this.. What is the problem you are trying to solve? There are cases where you want to manage failures yourself but...
February 9, 2011 at 1:52 pm
Not a problem. I hope it all works out for you. Database Mail for me is very nice to work with. I met the gent who wrote...
February 9, 2011 at 1:48 pm
With the retries I mentioned I brought my failure count down to near zero and most of those were people who no longer worked for us. Exchange won't accept...
February 9, 2011 at 12:46 pm
I'm wondering if you might not be patched..
Please see this URL http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/e0954385-b96a-46db-ab03-7c4c803e8d1d
It seems to be similar.
CEWII
February 9, 2011 at 12:34 pm
Viewing 15 posts - 1,606 through 1,620 (of 4,272 total)