Forum Replies Created

Viewing 15 posts - 31 through 45 (of 155 total)

  • RE: DB conversion to new collation; unexpected query results using collate

    The link is great.  I have looked for those.

    I think I know the problem.  I didn't expect there to be any data that really got lost in conversion.  We haven't...

  • RE: DB conversion to new collation; unexpected query results using collate

    Thanks for the response.  

    I guess another just as appropriate question should have been, if the comparison si true and the differences are there becuase there is not an equivalent...

  • RE: xp_sendmail - empty subject

    I have recently had this issue when migrating servers adn the caching was the fix.  Thanks everyone.

  • RE: Can''''t truncate log becuase of pending replication

    What does it do if you only drop the subscribers and don't touch the publications?  My understanding is that log file truncations are held up when subscribers have not received their...

  • RE: Assigning A User To A Scheduled Job

    Carl Federl, Thank you Thank you! 

    I have never seen anyone give a way to allow logins to view the jobs they don't own UNLESS they were an SA.  Your...

  • RE: Regular Patches

    Wow, I wasn't aware of the dual numbering convention.  I guess I've always lucked out and got the right patch - or have I? 

    What about KB933097.  It's advertised as...

  • RE: Nightmares

    Scarriest DBA story for me was an almost story. 

    Oh, I've had scary moments, like the realization that you have a corrupt purchasing database because of a raid problem and...

  • RE: Working More?

    I changed jobs to work ~ 40 hours a week.  5 years ago I was on call 365 days a year and often got calls in addition to 45 daytime...

  • RE: RS SP2 install RSCLIENTPrint via cab file, is there an MSI?

    We never did get the MSI built.  What we did was change a security setting in AD that allowed non admins to install signed updates.  This not only solved this problem,...

  • RE: Plasma or Diamond?

    I think the surprise gifts are the best.  She was thinking about you.

  • RE: Plasma or Diamond?

    Where the tickets for a special occasion or just a surprise gift?

  • RE: Plasma or Diamond?

    As a wife, mother, and DBA I don't want a plasma TV for my 25th wedding aniversary.  I think some gifts are just what they are, a statement of your...

  • RE: 640

    2 years ago - 10 active/active clusters (some NT4 running SQL7, rest were windows 2000, sql 2000 GEO Clusters), about 120 other servers running multiple instances on some, some dev, some production...

  • RE: lock a subset of a table from update or insert

    Thank you for all the ideas. 

    I considered the locking based on an index, but I just find that a little too...

  • RE: lock a subset of a table from update or insert

    What I don't understand is how a transaction isolation level will prevent inserts into tableA unless TableA is completely locked.  The best I can do on inserts is assume that inserts would...

Viewing 15 posts - 31 through 45 (of 155 total)