Differentiate between "system" and "user" SQL views

[Doug]

When looking at the schema of a SQL server database from Access, how do I
differentiate between views I've created on the server ("User") versus the
system views? I wrote a data extraction utility for Access years ago. When
I build the view definitions on a SQL2000 machine, all that's returned when I
interogate the schema are the views I've created. On SQL2008, however, it's
returning all of the "System" views in the database as well. I want to be
able to ignore the sytem views and only build the definitions for the views
I've created.

I'm accessing the schema using:

Cnn.Open strConnect, Me.txtUsername, Me.txtPassword
Set rstSchema = Cnn.OpenSchema(adSchemaTables)

Using: rstSchema!table_type it retrieves a list of views, but it
includes the system views as well. Is there an attribute that will allow me
to identify the system views and ignore them?

Thanks!

 

[Stefan Hoffmann]

hi Doug,

I build the view definitions on a SQL2000 machine, all that's returned when I
interogate the schema are the views I've created. On SQL2008, however, it's
returning all of the "System" views in the database as well.

This has nothing to do with Access or VBA, but with the separation of
users and schema:

http://msdn.microsoft.com/en-us/library/ms190387.aspx

btw, this already happend in SQL Server 2005.

I think you need to invest the time to redo the work to fit into the
"new" environment.


mfG
--> stefan <--