Building a second merge publication from a db, I'm getting an error 'Invalid
Column Name XXXXX' on gernerating the initial snapshot. The column
definitely exists. Anyone seen this behaviour before and maybe offer some
guidance?
Looks like this issue may be fixed in SP4
http://support.microsoft.com/kb/821535
"Tony Toker" <xyzzy@.identic.co.uk> wrote in message
news:crdj1r$rn3$1$8302bc10@.news.demon.co.uk...
> Building a second merge publication from a db, I'm getting an error
'Invalid
> Column Name XXXXX' on gernerating the initial snapshot. The column
> definitely exists. Anyone seen this behaviour before and maybe offer some
> guidance?
>
>
|||Thanks again for the help Paul, looks like we were posting simultaneously.
"Tony Toker" <xyzzy@.identic.co.uk> wrote in message
news:crduu6$f5i$1$830fa795@.news.demon.co.uk...[vbcol=seagreen]
> Looks like this issue may be fixed in SP4
> http://support.microsoft.com/kb/821535
>
>
> "Tony Toker" <xyzzy@.identic.co.uk> wrote in message
> news:crdj1r$rn3$1$8302bc10@.news.demon.co.uk...
> 'Invalid
some
>
Showing posts with label initial. Show all posts
Showing posts with label initial. Show all posts
Monday, March 12, 2012
Friday, February 24, 2012
interview question
here is a question asked in a interview:
u created the sales database with the initial size of hte transaction log of 50 mb with autogrow, but no autoshrink
u do not make any backup and donot set the truncate log on check point option to on.
what will be the transaction log size after the next check point has passed?Umm... >= 50mb|||You are in a job interview where the person hiring asks you inane and pointless questions that have little or no value in either database administration or database design, and for which the answers could easily be looked up in Books On Line. At the end of the interview, you are offered the job at a substantial salary bump. Do you work for the dolt, or do you continue seeking an employer that has actual competence?|||lol@.blindman. In the instance above, you tell him he hasn't provided you enough information (which he hasn't btw). If he could do some research though, create a business proposition for why he should waste your time answering stupid questions, get business signoff, send it through QA and user-acceptance testing, then test the release, you'll have a production answer for his highness right away.|||First, there's no "Trancate on checkpoint" in 2K, which means they are talking about 7.0 or 6.5, which is bad in itself.
Second, unless a user process kicked in within less than 0.00000001 millisecond after the "create database..." statement completed, peterlemonjello's answer is almost absolutely correct, - except it will be 50MB exactly, not more or equal to.|||hmmm what an interesting way of asking for clarification... I like it. :D
by the way, it was't me who was being interviewed and it was a colleague of mine, I wasn't sure about the question itself so thought to get some expert comments from the guru's here.
anyways thnks for the replies :p
u created the sales database with the initial size of hte transaction log of 50 mb with autogrow, but no autoshrink
u do not make any backup and donot set the truncate log on check point option to on.
what will be the transaction log size after the next check point has passed?Umm... >= 50mb|||You are in a job interview where the person hiring asks you inane and pointless questions that have little or no value in either database administration or database design, and for which the answers could easily be looked up in Books On Line. At the end of the interview, you are offered the job at a substantial salary bump. Do you work for the dolt, or do you continue seeking an employer that has actual competence?|||lol@.blindman. In the instance above, you tell him he hasn't provided you enough information (which he hasn't btw). If he could do some research though, create a business proposition for why he should waste your time answering stupid questions, get business signoff, send it through QA and user-acceptance testing, then test the release, you'll have a production answer for his highness right away.|||First, there's no "Trancate on checkpoint" in 2K, which means they are talking about 7.0 or 6.5, which is bad in itself.
Second, unless a user process kicked in within less than 0.00000001 millisecond after the "create database..." statement completed, peterlemonjello's answer is almost absolutely correct, - except it will be 50MB exactly, not more or equal to.|||hmmm what an interesting way of asking for clarification... I like it. :D
by the way, it was't me who was being interviewed and it was a colleague of mine, I wasn't sure about the question itself so thought to get some expert comments from the guru's here.
anyways thnks for the replies :p
Subscribe to:
Posts (Atom)