Running sysfiles on a database, bringing in error.

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  April 30, 2015 at 11:03 am

  #303583

  HI Experts,

  Whenever I'm runing query against the below database alone, it throws me the error. Any suggest why this happens?

  use [AdventureWorks_2005]

  SELECT * FROM dbo.sysFILES

  OR

  SELECT * FROM [AdventureWorks_2005].[sys].[SYSFILES]

  Error- >

  Msg 208, Level 16, State 1, Line 2

  Invalid object name 'dbo.sysFILES'

  Thanks.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 30, 2015 at 11:15 am

  #1794798

  SQL-DBA-01 (4/30/2015)

  ---

  HI Experts,

  Whenever I'm runing query against the below database alone, it throws me the error. Any suggest why this happens?

  use [AdventureWorks_2005]

  SELECT * FROM dbo.sysFILES

  OR

  SELECT * FROM [AdventureWorks_2005].[sys].[SYSFILES]

  Error- >

  Msg 208, Level 16, State 1, Line 2

  Invalid object name 'dbo.sysFILES'

  Looks like you are running on a server with a case sensitive collation, try this:

  use [AdventureWorks_2005]

  SELECT * FROM sys.sysfiles

  OR

  SELECT * FROM [AdventureWorks_2005].[sys].[sysfiles]

• Eirikur Eiriksson

  SSC Guru

  Points: 182947

  More actions

  May 3, 2015 at 4:01 am

  #1795217

  SQL-DBA-01 (4/30/2015)

  ---

  HI Experts,

  Whenever I'm runing query against the below database alone, it throws me the error. Any suggest why this happens?

  use [AdventureWorks_2005]

  SELECT * FROM dbo.sysFILES

  OR

  SELECT * FROM [AdventureWorks_2005].[sys].[SYSFILES]

  Error- >

  Msg 208, Level 16, State 1, Line 2

  Invalid object name 'dbo.sysFILES'

  Quick note, sys.sysfiles is a backward compatibility view (SQL Server 2000 system tables) and should not be used, suggest you use the sys.master_files view instead.

  

  BTW you are getting this error because the sysfiles are in the sys schema, not in the dbo schema.

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  May 4, 2015 at 9:08 am

  #1795377

  Eirikur Eiriksson (5/3/2015)

  ---

  SQL-DBA-01 (4/30/2015)

  ---

  HI Experts,

  Whenever I'm runing query against the below database alone, it throws me the error. Any suggest why this happens?

  use [AdventureWorks_2005]

  SELECT * FROM dbo.sysFILES

  OR

  SELECT * FROM [AdventureWorks_2005].[sys].[SYSFILES]

  Error- >

  Msg 208, Level 16, State 1, Line 2

  Invalid object name 'dbo.sysFILES'

  Quick note, sys.sysfiles is a backward compatibility view (SQL Server 2000 system tables) and should not be used, suggest you use the sys.master_files view instead.

  

  BTW you are getting this error because the sysfiles are in the sys schema, not in the dbo schema.

  Actually, the following works just fine when run on my SQL Server 2012 DE installation:

  select * from dbo.sysfiles;