Maximum Capacity of Triigers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Maximum Capacity of Triigers

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-07-18 : 07:02:44

Hi all,
What is the maximum capcaity of creating the same tringger into a single table..?
-- KK

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-18 : 07:12:42

What do you mean by max capacity?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-07-18 : 07:13:33

i just created 2500 triggers on that table

So What is The Limit..?

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-18 : 07:19:28

It is limited by the by the number of objects in the database.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-07-18 : 07:25:05

i just tested in master database only. In that server There is nothing except default db's and tables

can u please say me the exact answer.
Regards
KK

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-07-18 : 07:58:54

I know most of the gurus are avail in this forum. but no body replied for my question.

-- KK

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-18 : 08:21:55

quote:
Originally posted by CSK

I know most of the gurus are avail in this forum. but no body replied for my question.

-- KK

nr already answered your question !!
Still if you want from horse's mouth, type "capacity specifications-SQL Server" in BOL index (without quotes)

Harsh Athalye
India.
"Nothing is Impossible"

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-18 : 08:36:57

There is no exact answer.
You can have 2,147,483,647 objects in a database - a trigger will be one of those objects.
So it depends on how many other objects there are.
That includes tables, sp, functions, indexes, statistics, ...

Anyway probably a lot more than you need

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-07-18 : 08:59:09

quote:
Originally posted by nr

There is no exact answer.
You can have 2,147,483,647 objects in a database - a trigger will be one of those objects.
So it depends on how many other objects there are.
That includes tables, sp, functions, indexes, statistics, ...

But nr, we can write trigger only for tables/views, so actually no. of triggers should be limited only by the number of tables/views

Harsh Athalye
India.
"Nothing is Impossible"

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-18 : 09:49:42

quote:
Originally posted by harsh_athalye

quote:
Originally posted by nr

There is no exact answer.
You can have 2,147,483,647 objects in a database - a trigger will be one of those objects.
So it depends on how many other objects there are.
That includes tables, sp, functions, indexes, statistics, ...

But nr, we can write trigger only for tables/views, so actually no. of triggers should be limited only by the number of tables/views

Harsh Athalye
India.
"Nothing is Impossible"

Nope - you can have many triggers on a single table/view.
It's not restricted at all byt the number of tables/views.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources