March 14, 2008 at 2:02 am
What does this mean:
"If you are using any object type code as “S” this will not work. System tables (S) are not exposed"
Does it mean you can not use S as a table name for instance?
March 14, 2008 at 11:40 am
The sysobjects table returns a list of every object in the database. One of the columns is Object Type which is "P" for a stored procedure, "V" for a view, "T" for a user table, etc., including "S" for a System Table.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 14, 2008 at 11:46 am
Just to clarify: Yes, you can use "S" as a table name.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply