Archives / 2005 / May
  • The SysFiles table and System stored procedures

    It was an interesting observation yesterday that, when we try to create a system stored procedure that access the sysfiles table, the procedure always takes the data for sysfiles table of the master database only, and not from the database from where we run the StoredProcedure. This is happening because the Stored Procedure gets listed as a 'user' Stored Procedure and not as 'system' .