Forum Replies Created

Viewing 15 posts - 3,361 through 3,375 (of 3,605 total)

  • RE: Migrating Logins To Another Server

    Thats the baby. Thanks

  • RE: Worst Practice - Spaces in Object Names

    I agree with this 100%

    • Don't use spaces in table names
    • Stick to alphanumerics, (preferably without the numerics unless you absolutely must)
    • Don't use reserved words for tables i.e have a...
  • RE: Migrating Logins To Another Server

    Can anyone remember the SP that fixes orphaned users?

    I seem to remember that if the login name and user name were the same it assigns a matching SID.

  • RE: What did you do before SQL?

    Keith,

    You sound as disillusioned with UK Education as the parents who care!

    My experience of school IT was 30 of us kids sharing a Commodore pet, then shortly afterwards having 8...

  • RE: Where Do I Want To Go Today? - From the Field 2

    I would like the following features within Yukon.

    • Upgradeable MS XML component. At present SQL2000 locks you into MS XML3.0
    • Not really a SQL Server issue but ...
  • RE: What did you do before SQL?

    I always wondered what it was that made something other than an animal masculine or feminine.

    Someone told me that in French if a bloke liked it then it would be...

  • RE: What did you do before SQL?

    I tend to think that software engineers are to programmers what mechanical engineers are to car mechanics.

  • RE: What did you do before SQL?

    • Fruit picker
    • Gardener
    • Odd job man
    • Commodore Pet Basic and 6502 programmer
    • dBASE II/Clipper programmer
    • HP3000 Image3000 programming
    • Cognos Quiz programming
    • VB Access SQL developer
    • Dad
    • Statistician
    • Web DBA and CMS Specialist

    Still doing...

  • RE: Where Do I Want To Go Today? - Real Time Defragging

    I've seen an article somewhere describing how existing file systems such as FAT & NTFS are going to be replaced by databases. The argument was that the existing file...

  • RE: Dubious DBA Statement

    Thanks Tom, that is a very clear description.

    Does anyone know if this a generic SQL Server/Sybase issue. I see that alzdba has experienced it with SQL7 SP2 but does...

  • RE: Dubious DBA Statement

    quote:


    How "vast" are we talking? Hundreds/sec? thousands? Do you have any idea of peak v avg numbers?


    September 8, 2003 at 10:45 am

    #473057

  • RE: Stored Procedure Development Cycle

    Philip,

    What you need is a good document managements system plus the internal procedures in place to use it.

    Ideally the documents need version control so I would say have an official...

  • RE: Stored Procedure Development Cycle

    Yep, agree with all this but I would add documentation to the list.

    The situation I am in is where the stored procedures are effectively an interface to the database layer....

  • RE: MS03-033 or MDAC 2.8 Which would you install?

    If there is a new configuration change then the main thing is to test it away from potentially embarassing situations.

    We got stung in the jump from 2.5 to 2.6 because...

  • RE: Where Do I Want To Go Today? - Upsert

    I like the idea behind WITH UPDATEEXISTING.

    I feel it needs three settings.

    • ON - Does what it says on the tin.
    • OFF - Performs INSERTS only but throws errors if ...

Viewing 15 posts - 3,361 through 3,375 (of 3,605 total)