Forum Replies Created

Viewing 15 posts - 5,236 through 5,250 (of 5,356 total)

  • RE: NT Groups and SQL Server Access Right

    There is a search on the new login form. Have you tried this?

    I would go for QA, although I fear the results will be the same.

    Is the computer running...

  • RE: NT Groups and SQL Server Access Right

    Hi,

    if you add a new login via EM and click on the button right of name, you have the chance to browse the valid NT users/NT groups in the domain...

  • RE: Boolean or Integer for comparison

    Hi,

    the boolean true/false values are different representation of 1 or 0. I don't think there are significant performance differences between an integer and a bit. The bit field might be...

  • RE: How to keep and restore the deleted records?

    Hi,

    sorry for asking this, but how can your records be deleted by accident

    I use another approach to 'delete' records. I don't allow a physical delete, but a...

  • RE: how to split a field?

    Hi,

    sorry for being that late!

    You can write a script in QA to handle this. As this is hopefully one-time action, I think a cursor is quite ok for it.

    use zz_fai_play...

  • RE: how to split a field?

    Hi,

    it should be possible to use conditional processing depending on what value is in the second field. Can you provide more information on what value field 2 can contain and...

  • RE: NT Groups and SQL Server Access Right

    Hi,

    are you doing this via EM? Which SQL Version?

    Cheers,

    Frank

  • RE: Linking SQL Server table with access forms

    Hi,

    maybe a little late for an answer, but...

    An issue with linked SQL Server tables in Access I stumble over very often is that, every time you change something in the...

  • RE: Forum Software error

    In addition to my previous post

    I'm running Snitz Forums 2000 Version 3.4.03 for internal reasons and do not receive the described error

    Cheers,

    Frank

  • RE: Testing text field for content

    Hi David,

    quote:


    p.s. I disagree with 'You cannot use CHARINDEX on textfields', I can on SQL7 SP4.


  • RE: Use Backup to Copy a DB

    quote:


    It takes a special sort of genius to name a function so that is so short it qualifies for a noise...

  • RE: Use Backup to Copy a DB

    Hi,

    quote:


    What exactly does N'string' do? Is it really necessary?


    not sure if it is really...

  • RE: CPU field in sysprocesses

    quote:


    set nocount on

    declare @cpu_busy int

    declare @IO_BUSY int

    declare @IDLE int

    declare @percent decimal

    But I'm getting a result of 0. I know that's not...

  • RE: Customer or Customers?

    Hi,

    as mentioned above, naming convention are mainly personal preferences, but if but develop in a team it can be quite *funny*, if each developer uses his own convention. In this...

  • RE: Testing text field for content

    Hi,

    well, after thinking about this over the weekend, just my 2 cents.

    Can't you just check for IS NULL?

    I've tried this on one of my textfields and it seems to work.

    Cheers,

    Frank

Viewing 15 posts - 5,236 through 5,250 (of 5,356 total)