Viewing 12 posts - 1 through 12 (of 12 total)
For SQL Server 2005, use restore to another instance will not work b/c of the LSN error mention on my prior replied post.
For SQL Server 2008 or Denali, I heard...
April 11, 2011 at 4:01 pm
Gail,
Thanks!
I got verbal confirmation that the Logical Sequence Number (LSN) would be different in each instance of the Database.
Hence, Restore will indeed gives us the Error you indicated.
Thanks,
Jeffrey
April 11, 2011 at 3:59 pm
Gail, thanks for the quick reply.
How about a little twist?
Instead of #3 below,
How about on another box, restore from the old instance full backup and then restore differential transactional...
April 11, 2011 at 1:02 pm
Thanks for your question.
I am planning to restore the transactional log of New Instance's new data on top of the (Old Instance with its New Data).
Combine data = (Old Instance...
April 11, 2011 at 12:54 pm
Will this manual replication plan work?
1.To be more specific, at Date1, we want to detach US DB, copy and attach to PacRim.
2.On Date1, also turn on differential backup transaction log...
April 11, 2011 at 10:36 am
Very informative!
Follow up question, If column ID defined Identity not for replication.
How does SQL Server tells the difference between a user calling a store proc to insert or a batch...
April 11, 2011 at 9:27 am
Thanks for the info.
With the understanding, that Visual 2008 BIDS will run SSIS 2008 package.
To be more specific, my question is directed at the command run statement in production...
April 11, 2011 at 9:04 am
So what is the final answer?
Will SSIS 2008 package run with SQL Server 2005 DTExec?
Yes or No or Maybe Yes.
Regarding maybe Yes, I am referring to simple packages with simple...
April 7, 2011 at 9:59 am
Thanks all who have replied.
To sum it up, "In general, you use table variables whenever possible except when there is a significant volume of data and there is repeated use...
March 31, 2010 at 10:06 am
Jason,
The purpose is to modulize all my big store procedures into smaller functions or store procedures.
Each store procedures has many #temp tables.
The question is which is best suited for passing...
March 31, 2010 at 8:54 am
Jason,
Thanks for your experience that CTE 1 million records is not a problem.
That is for 1 user right? assuming 8k per row x 1 million rows is about 8...
March 30, 2010 at 11:38 pm
Thanks for affirming what tempdb/table variables/CTE differences.
Based on what I read, Table variables and CTE are using memory (RAM).
If a store proc uses either one of them, then developer must...
March 30, 2010 at 10:32 pm
Viewing 12 posts - 1 through 12 (of 12 total)