August 29, 2007 at 6:40 am
HI All,
I recently came across some code that looked like this.
IF
EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[!ActiveSchema!].[Marriage]'))
I can't find any documentation on [!ActiveSchema!]
I can only guess and assume that the object_id Function turns that "special" value intot he current schema being used!
Please could someone let me know if this is true or what actually happens here?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
August 29, 2007 at 6:51 am
Hi All,
Sorry about this.
It seems that with some further coding and testing that this [!ActiveSchema!] is actually jsut something that needs to be replaced with a real schema word e.g. [dbo]
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply