At the time of creating triggers magic tables will be created.

Where are magic tables stored ? Is it in the same database
where it is created ?

Question Posted / raja

Answer Posted / raja

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain indexed views and partitioned view with their syntax.

1100

Define full outer join?

904

what are user defined datatypes and when you should go for them? : Sql server database administration

976

How many joins in sql server?

914

Is natural join and equi join same?

923

How to update multiple rows with one update statement in ms sql server?

1161

List out what other servers you can use with ssrs?

135

How do I find the size of a sql server database?

894

What is the maximum number of index per table?

1034

What is Sqlpaging in SqlServer 2005 ?

1024

What is the recommended total size of your memory optimized tables?

928

what stored procedure would you use to view lock information? : Sql server administration

929

Explain different forms of normalization?

900

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1146

What happens when converting big values to integers?

969