May 2012
2 posts
1 tag
1 tag
Order of parameters matters for sp_trace_create
Because each parameter can be specified by name, The order of each parameter in a T-SQL stored procedure call usually does not matter. For example, the stored procedure sp_spaceused takes two parameters and accepts both orders.
Execution of this script:
EXECUTE msdb.dbo.sp_spaceused
@updateusage = 'true',
@objname = N'msdb.dbo.sysjobs';
GO
EXECUTE msdb.dbo.sp_spaceused
@objname =...
