Viewing 15 posts - 241 through 255 (of 2,840 total)
TBH, I am not sure. But we did create the logshipping first and then Replication.
-Roy
October 28, 2011 at 9:10 am
It is strange that you are getting this issue. We have Replication set up and we have warm standby (but on different physical server, same name) as well. One question,...
-Roy
October 28, 2011 at 8:34 am
On the subscriber, did you restore the DB with log shipping with the same as that of the subscriber Database? As far as I know If you want to keep...
-Roy
October 28, 2011 at 8:10 am
Not an easy thing to do unless there has already been a practice of peer review. That is the simple truth. We (DBA) had a tough time to make review...
-Roy
October 27, 2011 at 12:53 pm
SQLRNNR (10/26/2011)
Lynn Pettis (10/26/2011)
Okay, I'm sorry but that was just gross.Happy Halloween :-D:-D
So that is how a brain looks like? I thought is was just some mushy stuff filled to...
-Roy
October 26, 2011 at 2:20 pm
WayneS (10/25/2011)
Roy Ernest (10/25/2011)
-Roy
October 26, 2011 at 6:49 am
I am a BB guy. In our island iPhines are not that common. Androids are there but you will see more BB. Everyone loves the messenger service of BB.
-Roy
October 25, 2011 at 2:53 pm
Whichever method you will eventually choose, it is always recommended to take a back up of all the DB. I prefer migrating to another server since there is a good...
-Roy
October 24, 2011 at 8:21 am
Creating any kind of index depends on your queries. Your CL index can be your PK or can be something else. It all depends on how you are using the...
-Roy
October 24, 2011 at 8:19 am
Your compressed back up, Just Zip it up using WinRAR or another app like that and split it into smaller files and then put it together at the destination. It...
-Roy
October 24, 2011 at 7:53 am
I did not know that you had a long way to go to get the Back up. I thought it was just another office right beside. Sorry, My bad.
Other...
-Roy
October 24, 2011 at 7:29 am
Take a look at this URL and you can see if there is anything to be worried about. So far I do not see anything outwardly to be concerned about.
-Roy
October 24, 2011 at 7:23 am
This might be a silly idea but there are some new detachable HD, kind of like a USB stick but it is for Servers. You could attach it, copy the...
-Roy
October 24, 2011 at 7:19 am
The PRINT statement is useful when you are debugging and running from SSMS. I do not see why you would want to have it in a SP that will be...
-Roy
October 21, 2011 at 9:37 am
Off topic, the in parameter Varchar(MAX) does not give a good feeling. Are you sending a comma separated string?
Also are you checking for SQL Injection on the parameter that...
-Roy
October 21, 2011 at 9:07 am
Viewing 15 posts - 241 through 255 (of 2,840 total)