Showing posts with label openrowset. Show all posts
Showing posts with label openrowset. Show all posts

Tuesday, March 20, 2012

an OpenRowset little doubt

Hi all.

Seeing that the old system table syslang is no longer updateable(Not even in DAC) i decided to take a look at the definition of it, just to see where the languages are stored.(out of curiosity)

Select Object_Definition(Object_Id('SysLanguages'))

and it returns

Select .......

FROM OpenRowset(TABLE SYSLANG)

The odd thing is I tried to run that query but it gives me an error telling an incorrect sintax near TABLE.

so, the question is if does anybody knows why i can't run the same query that the object_definition returned?

any comments are most apreciated

This syntax works only in mssqlsystemresource database context.|||

Thanks a lot! i copy and attached the mssqlsystemresource as an standar database and it worked out.

Thanks for your help!