Viewing 15 posts - 301 through 315 (of 1,790 total)
Dj463 (2/24/2011)
As i am using SQL Server 2005, i think the update statement is delivered as update only, but not pair of delete/insert.
Yes, you are correct. I guess I am...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 9:55 pm
It's odd that the row was not caught even though logreader was turned off. Did it possibly get deleted from msrepl_commands / msrepl_transactions or did you execute an sp_repldone? If...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 2:51 pm
Dj463 (2/24/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 2:47 pm
Do you have a solution then and / or a task outline of the steps you will need to take? If not, post what you have so far and we...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 1:39 pm
Thanks for following up and you're welcome. 😀
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 12:39 pm
edwardw 90939 (2/24/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 12:24 pm
What are your plans for the migration after reading that document? Can you put together an outline of the steps you are going to follow and reply back with that?...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 10:26 am
Oops - didn't read that all the way. You would also have to build in a "Use" @db_name in there as well so that the string was something like;
USE DBName;...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 9:51 am
aroatenberry (2/24/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 9:48 am
You should review this MS LINK as it provides a great process for doing a planned move. My recommendation would be to write a script to create the file location...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 9:43 am
Ian Scarlett (2/24/2011)
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
OMG, that makes me feel...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 8:20 am
Grant Fritchey (2/24/2011)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 24, 2011 at 7:36 am
...and you could also use with transactional replication with updatable subscriptions OR IF your data is mutually exclusive you could use peer-to-peer replication. Both of which are far less overhead...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 2:51 pm
Krasavita (2/23/2011)
But how to check RAM?
SQL Server will still not start correct? If so, then you have to get this information from Windows.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 1:46 pm
Thanks, that is what I thought too, which is not server version which is why I was asking. 🙂
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 23, 2011 at 1:27 pm
Viewing 15 posts - 301 through 315 (of 1,790 total)