Viewing 15 posts - 16 through 30 (of 170 total)
opc.three, first, thanks for pointing out the USE statement. I simply missed that. Second, I just re-checked and the procedure is correct.
I'll admit, in all my testing, I...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
January 28, 2013 at 7:10 am
When I said we were going ahead with the idea that the backup on the 26th and the diff on the 5th would be good, I meant that was the...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
December 7, 2011 at 12:39 pm
Thanks Dev and Steve. I am going forward with the idea that the full from the 26th and the diff from the 3rd are intact. I am also...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
December 6, 2011 at 8:30 am
History tells me this is not going to happen with this system. That doesn't mean I won't try, though.
Anyway, I realize an index is the best remedy for poor...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
June 3, 2010 at 2:15 pm
I would love to add an index but this is a third-party database so it's not going to happen - at least not by me. The vendor would have...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
June 3, 2010 at 2:02 pm
Caching sounds plausible but both these databases have been out there for at least a week and during that time both the server and my machine have been restarted. ...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
March 10, 2010 at 4:33 pm
As usual, I found the answer just a few minutes after submitting this.
The change is with the metadata permissions and how those come into play when querying the catalog views....
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
December 1, 2009 at 3:11 pm
I am just getting back from the holidays and getting caught up.
I did get my problem resolved and it was with using the sp_browsereplcmds procedure. I had been having...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
December 1, 2009 at 9:20 am
No, this is transactional replication.
Restarting wouldn't help because these are legitimate errors in the data. Most of the time, there are one or two scenarios where associated data can...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
November 23, 2009 at 8:07 am
Here some more info that may, hopefully, help better explain what I am looking for.
When I get a replication error, I see something like:
The INSERT failed because the "customer" does...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
November 20, 2009 at 10:00 am
Here some more info that may, hopefully, help better explain what I am looking for.
When I get a replication error, I see something like:
The INSERT failed because the "customer" does...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
November 20, 2009 at 10:00 am
Just an update. The problem was a typo in the SPN setup. There was a small piece missing in the domain qualifier.
I looked at it a million times...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
November 4, 2009 at 7:50 am
What do you mean by "1.I Hope your user is not a member in windows group"?
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
November 4, 2009 at 7:15 am
Thanks Steve but, yes, I have logged in as the service account and the command line works fine. The file is also not in use.
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
July 20, 2009 at 10:57 am
Yeah, I logged on to the server and ran the exact command that was created in the script because I was afraid maybe some kind of OS change might have...
----------------------------------------------------------
01010011010100010100110000100000010100110110010101110010011101100110010101110010
001000000101001001101111011000110110101101110011
July 20, 2009 at 9:24 am
Viewing 15 posts - 16 through 30 (of 170 total)