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.
| Author |
Topic |
|
Amazing
Starting Member
2 Posts |
 Posted - 2007-03-11 : 03:33:11
|
| Can anybody help me with this command code that stops at the execute and eventually gives timeout.Dim MM_Cmd, strSQL, strSQL2, strSQL3, strSQL4Set MM_Cmd = Server.CreateObject("ADODB.Command")MM_Cmd.ActiveConnection = MM_connAdmin_STRINGstrSQL = "update Products_Categories set Depth=NULL, Lineage=''"MM_Cmd.CommandText = strSQLMM_Cmd.CommandType = 1'MM_Cmd.CommandTimeout = 0MM_Cmd.Prepared = TrueMM_Cmd.Execute strSQLSet MM_Cmd = NothingRegardsAmazing |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-03-11 : 03:36:58
|
How many rows are there in the Products_Categories?More than "Millions"?Are there Triggers on the Products_Categories table? - particularly recursive triggers, or triggers with some external process on them (such as "Mail me if the Depth gets set to NULL"  )Kristen |
 |
|
|
Amazing
Starting Member
2 Posts |
Posted - 2007-03-12 : 12:50:45
|
| MAX 50 records !!!No triggers, nothing.I solved the problem just recreating the table from scratch.It seems some internal corruption occurred, would like to know.Same problem occurred on anothe table (about 110 records). I had to recreate the table from scratch and insert data MANUALLY. If I import or copy data from another DB or even same DB but different table somehow it does not work. I cannot make a consistent line of occurence and therefore I am not able to grasp what went wrong and where in thesee two tables but in no other that are updated the same way ... Does anybody knows how to copy data from a table to another without getting strange things happening? |
|
|
|
|
|
|
Command or execute not working