|
select
[Name]=q.name,
[ObjectId]=q.object_id,
[Principal]=p.name , --if 0 than SELF
[ExecuteAsPrincipalId]=q.execute_as_principal_id,
[Schema]=s.name,
[MaxReaders]=q.max_readers,
[ActivationProcedure]=q.activation_procedure,
[IsActivationEnabled]=q.is_activation_enabled,
[IsReceiveEnabled]=q.is_receive_enabled,
[IsEnqueueEnabled]=q.is_enqueue_enabled,
[IsRetentionEnabled]=q.is_retention_enabled,
[FileGroup]=fg.name,
[ActivationProcedureId] = spsch.object_id,
[ActivationProcedureSchema] = spsch.name
from sys.service_queues q
left join sys.database_principals p on q.execute_as_principal_id=p.principal_id
join sys.schemas s on s.schema_id = q.schema_id
INNER JOIN sys.internal_tables AS it ON q.object_id = it.parent_object_id
INNER JOIN sys.indexes AS ind ON ind.object_id = it.object_id and ind.index_id < 2
INNER JOIN sys.filegroups AS fg ON fg.data_space_id = ind.data_space_id
LEFT JOIN
(SELECT '[' +s2.name+'].['+sp.name+']' AS FullSpName,s2.name , sp.object_id from sys.procedures AS sp JOIN sys.schemas s2 ON s2.SCHEMA_ID=sp.schema_id) AS spsch ON spsch.FullSpName=q.activation_procedure
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
My name is Robert Kanasz and I have been working with ASP.NET, WinForms and C# for several years.
MCSD - Web Applications
MCSE - Data Platform
MCPD - ASP.NET Developer 3.5
- Web Developer 4
MCITP - Database Administrator 2008
- Database Developer 2008
MCSA - SQL Server 2012
MCTS - .NET Framework 3.5, ASP.NET Applications
- SQL Server 2008, Database Development
- SQL Server 2008, Implementation and Maintenance
- .NET Framework 4, Data Access
- .NET Framework 4, Service Communication Applications
- .NET Framework 4, Web Applications
MS - Programming in HTML5 with JavaScript and CSS3 Specialist
Open source projects:
DBScripter - Library for scripting SQL Server database objects
Please, do not forget vote