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
 Old Forums
 CLOSED - General SQL Server
 Error 913: Could not find database ID: 102 ....

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-01-21 : 08:11:03
Boris writes "Hi...

I get this error sometimes when I try to create a view in my database (ONLY when I use a user-defined function in my view). The weird thing is that if there was anything wrong with the function itself then the view would never build ... but some views(in which I do use the function) build just fine:

"Could not find Databas ID 102: Database may not be activated yet or may be in transition"

I'd greatly appreciate your help.

Thanks!"

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2004-01-21 : 08:12:04
Do you connetct to another DB in your function? If yes then this may be the source of your problem.
Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2004-01-21 : 08:12:30
Do you connect to another DB in your function? If yes then this may be the source of your problem.
Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2004-01-21 : 08:13:06
Oops, double post, had some connection problems myself.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-21 : 12:21:20
Googled your error message and found this:

http://dbforums.com/arch/29/2003/7/753797

Tara
Go to Top of Page
   

- Advertisement -