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
 SQL Server Development (2000)
 Log File

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-21 : 09:14:49
Tanvir writes "Hello there ,

I am having a bit problem to retrieve some information in the sql server. What I am trying to retrieve is

Say I want to insert a record in the database. I wrote an insert statement. Nothing wrong in my sql statement but because of too many field in the database, sql server failed to write in the database. Is there any way so I can track all the statements, sql failed to write? Any kind of log or command.

Thanks in advance.

Tanvir"

izaltsman
A custom title

1139 Posts

Posted - 2002-03-21 : 09:20:20
Well, a SQL statement is not going to fail because of "too many fields"... So there probably is something wrong with your statement.

If you want to see everything that gets sent to the server, you can set up a profiler trace (look up "traces, creating" in BOL)


---------------
Strong SQL Developer wanted in the Boston area. Please e-mail if interested.
Go to Top of Page
   

- Advertisement -