Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

  • RE: update datetime field

    Antares66,

    I understood the contention business. The update trigger action in theory could lead to an infinite loop. With my situation, how would you move this to the SPs...

  • RE: update datetime field

    Andy,

    That is one amazing code. It works great. For mromm, I knew how to add getdate() to the default but I also knew that I had to write...

  • RE: Replication Error 21395 Column ID >255

    1) SQL Server 2000 with SP1.

    2) At first I had 1 table with 270 columns and I got error 20068. I broke the table into 2 tables (240 and...

  • RE: Too many columns (255) to replicate

    Is there an perfomance issue with respect to read and write to the view from an external app? It seems that every time you write to the view, SQL...

  • RE: Too many columns (255) to replicate

    What are the limitations a view has that a table doesn't? I know that it does perform a join between tables so you can treat as one. Can...

  • RE: Too many columns (255) to replicate

    The software application (C++) that logs data to the database was written by another group. Splitting the table will definitely impact their code. SQL Server doc. shows that...

  • RE: Single Trigger on multiple tables

    Isn't it better to use functions instead of stored proc. in this case?

  • RE: Backup to colocation

    I am running into the same problem. According to Microsoft support site, the machine that you are performing the backup must be part of a domain. If that...

Viewing 8 posts - 1 through 8 (of 8 total)