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)
 Trigger updation issues

Author  Topic 

sqllearner
Aged Yak Warrior

639 Posts

Posted - 2004-08-17 : 21:47:29
When an insertion is done to a table which has trigger this is the error that iam getting.This trigger call 4 stored procedures.What is this error about
Server: Msg 925, Level 18, State 1, Line 45
Maximum number of databases used for each query has been exceeded. The maximum allowed is 8.

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-08-17 : 23:11:41
Maximum number of databases used for each query has been exceeded. The maximum allowed is 8.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -