
July 13th, 2004, 12:37 PM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Trigger registering problem
I'm trying to create a trigger test as shown below on table test2 - which has around 1000 rows in MS SQL Server database:
CREATE TRIGGER test ON [dbo].[test2]
FOR insert
AS
Print 'inserted'
GO
Its pretty simple trigger - but it takes for ever to register this trigger.Other tables in the same database works fine.
any clues ??
thanks,
Ganesh A Gopalakrishnan.
|