Insert Statement

When I execute the INSERT statement on SQL Server 2000, the table on which I run this statement is not affected. What could be the problem? Could anyone please tell me what's the maximum size of a table in SQL Server 2000
Thanking you in advance.Choi
Please read this article in the BOL
"Estimating the Size of a Table"
"Choi" <anonymous@.discussions.microsoft.com> wrote in message
news:CFD1E2F3-E9DE-4E87-9FAB-68FC64912C40@.microsoft.com...
> When I execute the INSERT statement on SQL Server 2000, the table on which
I run this statement is not affected. What could be the problem? Could
anyone please tell me what's the maximum size of a table in SQL Server 2000.
> Thanking you in advance.|||Hi,
Check whether the implicit transaction is set to "on".
How to verify,
1. In Query Analyzer, go to tools -- Options
2. Go to connection Properties tab
3. Check whether SET IMPLICIT_TRANSACTIONS is selected.
If selected remove that option and re-run the insert statement.
Other possibility for this can be ,
BEGIN TRAN
insert statement
ROLLBACK TRAN
Thanks
Hari
MCDBA
"Choi" <anonymous@.discussions.microsoft.com> wrote in message
news:CFD1E2F3-E9DE-4E87-9FAB-68FC64912C40@.microsoft.com...
> When I execute the INSERT statement on SQL Server 2000, the table on which
I run this statement is not affected. What could be the problem? Could
anyone please tell me what's the maximum size of a table in SQL Server 2000.
> Thanking you in advance.