Viewing 15 posts - 2,041 through 2,055 (of 7,168 total)
Hollyz (2/11/2013)
What would cause this out of order sequencing? Is there anyway to maintain the ordering of the identity column in the right physical order of the table?
What you...
February 11, 2013 at 8:02 pm
Here is a recent thread with more information from some very trusted resources:
http://www.sqlservercentral.com/Forums/Topic1416031-1550-1.aspx
February 11, 2013 at 7:49 pm
I would do this in two steps:
1. Run an Execute SQL Task to retrieve the max ID from the destination table and store the result in a variable.
2. Run a...
February 11, 2013 at 7:11 pm
You can select values from your table into a Variable of Type Object using an Execute SQL Task. Then you can iterate over that Variable using the ForEach Loop Container...
February 11, 2013 at 4:58 pm
DB_Newbie2007 (2/11/2013)
1) The account that is configured to run SQL Server Agent service....
February 11, 2013 at 12:31 pm
DB_Newbie2007 (2/11/2013)
The job is actually run with a custom higher level account with full permissions in every database. Yes, it has full SA permissions... again, please no...
February 11, 2013 at 11:00 am
You will need 30 different Source and Destination combinations in your SSIS Package. Given how Excel work and the fact that concurrent access is not a good idea I would...
February 11, 2013 at 10:56 am
Any proxies in play?
February 11, 2013 at 7:36 am
nedneu (2/10/2013)
my project started 2 months ago, and alalready'i'mransferring over 100 tables on each process i run to the DWH.
i'll probably reach 200-300 tables pretty soon (a...
February 11, 2013 at 7:34 am
A SQL Agent Alert that leverages WMI could run a Job for you. Lookup SQL Agent Alerts and the WMI Event Class __InstanceCreationEvent.
You could also do this a few different...
February 11, 2013 at 7:29 am
I am not sure how you could alert based on one specific query causing 80% CPU use because SQL Server abstracts a lot of that but you could get a...
February 11, 2013 at 7:23 am
Rob Schripsema (2/5/2013)
I almost wish you had thrown in an option of '2012-04-01 10:00:00.000' to spice up the thinking a bit more. Of course, then I probably would...
February 11, 2013 at 7:14 am
When you say "crashed" what do you mean? Is the tran log backup file corrupt and unable to be restored? Where are you trying to restore this backup?
Are you...
February 11, 2013 at 6:57 am
Some DDL yes, but nothing by default for DML. You would have had to have a Trace running to capture the DML activity.
February 11, 2013 at 6:53 am
Viewing 15 posts - 2,041 through 2,055 (of 7,168 total)