Viewing 15 posts - 31 through 45 (of 100 total)
The transaction property for all of the tasks in the sequence container should be set to Supported. The sequence will open the transaction, and then the DFT's will join it....
July 20, 2010 at 6:22 am
Jim McLeod (7/15/2010)
Here's another fun question - what's the difference between a primary key and any other unique key, regardless of whether it's clustered or not?
PK allows NO nulls in...
July 20, 2010 at 6:19 am
Just as an explanation WHY you cannot restore a Transaction Log onto an unrestored DB.
Transaction logs contain a copy of the WORK that was done during a period of time...
July 16, 2010 at 12:49 pm
Hey doobya, change your severity level to 17 and run the EXACT SAME PROC and watch what happens.
For everyone else, the main line code raises the error, which then triggers...
July 16, 2010 at 8:49 am
hxkresl (7/15/2010)
Probably bad form to populate forum with 'thank yous' but very much appreciated.
I certainly agree with George, I appreciate the thanks. Let us know how it goes.
July 15, 2010 at 6:55 pm
Failover clustering is a Windows based solution that offers redundancy for the processor, memory, power supply, network cards, etc, but does NOT offer redundancy on your data. It requires a...
July 15, 2010 at 2:06 pm
doobya (7/15/2010)
First, there is NO "implicit Try..Catch" in C#. If you do NOT put a Try..Catch in the code, it will bubble the exception all the way back to the...
July 15, 2010 at 12:10 pm
@OP
How are you getting the original values of the data to display in the form? If it is coming from SQL Server, then why not put the data into a...
July 15, 2010 at 7:32 am
doobya (7/15/2010)
in VB6 you can control whether a given block of code is resumptive or not
in T-SQL only code that is EXPLICITLY DECLARED INSIDE A LOCAL TRY...
July 15, 2010 at 6:53 am
A for loop will execute the tasks a specified number of times, in other words 10 times, or 25 times, and the number of times is specified in the definition...
May 28, 2010 at 7:10 am
The approach that you have taken is typically the one that I recommend. 3rd party tools that try to back up SQL Server databases directly can be unreliable due to...
April 22, 2010 at 9:45 am
OK. I can't resist joining this one.
When I was in high school I worked in a shoe store (no Al Bundy jokes, please). We would send the newbies to get...
April 8, 2010 at 7:47 am
ankur_libra (4/7/2010)
Is it possible to change the default language installed on the SQL server 2005?
Our Scenario:-
On one of our esteemed client , we have a production SQL Server 2005...
April 8, 2010 at 7:41 am
Do you have a Mirror, Replicated table, or Database snapshot? If so, you could retrieve it from there. If not, then your only choice would be to restore the database...
March 4, 2010 at 8:21 am
Robert Frasca (12/10/2009)
I find it particularly amusing that some of you have the chutzpah to claim that Kalen Delaney is wrong. 🙂
Far be it for me to question Kalen...
December 10, 2009 at 11:09 am
Viewing 15 posts - 31 through 45 (of 100 total)