User Profile

Collapse

Profile Sidebar

Collapse
pvpkumar
pvpkumar
Last Activity: Sep 23 '06, 02:49 AM
Joined: Aug 11 '06
Location: Sharjah, UAE
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pvpkumar
    replied to Trigger problem in SQL
    in SQL Server
    It's not definitely because of the maximum no. of records pumped into the table. The maximum no. is either in billions or in trillions.

    The Trigger is working after re-installation of MS-SQL. I have a strong feeling that there is database tuning required, which is unknown to me.

    Please advise

    Thanks and best regards
    P.Kumar...
    See more | Go to post

      Leave a comment:

    • pvpkumar
      started a topic Trigger problem in SQL
      in SQL Server

      Trigger problem in SQL

      Getting a trigger problem in SQL. As the table grows the trigger stops working. Upon reinstallation of SQL the trigger starts working.

      The problem was encountered for the following database/table details

      1. Database size 2.25 GB
      Table size over 2 million records.

      2. Database size 250 MB
      Table size 50,000 records.

      Thanks

      P...
      See more | Go to post
      No activity results to display
      Show More
      Working...