Filestream directory structure

• gary1

  SSC-Insane

  Points: 21152

  More actions

  August 25, 2011 at 4:32 pm

  #390277

  I'm running the below query to find out the Filestream directory structure (http://www.sqlskills.com/blogs/paul/category/filestream.aspx) but the below error. Please advice

  Msg 208, Level 16, State 1, Line 1

  Invalid object name 'sys.sysrowsets'.

  SELECT o.name AS [Table],

  cp.name AS [Column],

  p.partition_number AS [Partition],

  r.rsguid AS [Rowset GUID],

  rs.colguid AS [Column GUID]

  FROM sys.sysrowsets r

  CROSS APPLY sys.sysrscols rs

  JOIN sys.partitions p ON rs.rsid = p.partition_id

  JOIN sys.objects o ON o.object_id = p.object_id

  JOIN sys.syscolpars cp ON cp.colid = rs.rscolid

  WHERE rs.colguid IS NOT NULL AND o.object_id = cp.id

  AND r.rsguid IS NOT NULL AND r.rowsetid = rs.rsid

  GO

  thanks

• bisht.kuldeep

  SSC Enthusiast

  Points: 194

  More actions

  August 26, 2011 at 12:49 am

  #1373593

  Yes, You Will Get This Error if You Try Access System Tables there are Round 58 System Tables (which you cannot access directly)

  select * from sys.all_objects where type_desc='SYSTEM_TABLE'

  You Need DAC(Dedicated Admin Connection) Connection inorder to access These Tables.

  Your Query Will Work If you Have DAC Connection.

  Thanks

  Kuldeep Bisht

  Simplion Technologies

  http://mssqlguide.kuldeepbisht.com/

  Kuldeep Bisht
  Simplion Technologies
  http://mssqlguide.kuldeepbisht.com

• gary1

  SSC-Insane

  Points: 21152

  More actions

  August 26, 2011 at 11:44 pm

  #1374189

  You Need DAC(Dedicated Admin Connection) Connection inorder to access These Tables

  Could you explain me the steps to connect sql instance using DAC?

  Thanks