-- 11/2/2010 5:49:26 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
-- @ObjectOwner:dbo
-- @ObjectName:enc
/*
Specific to SQL Server 2005.
Used for IndexColumnsInfoTrl class
 
The purpose of this script is to get object type information.
*/

use atoregistry;

SELECT o.type AS [Type],
CAST(OBJECTPROPERTY(o.object_id, N'IsMSShipped') AS bit) AS [IsSystemObject]
FROM sys.all_objects o, sys.schemas u 
WHERE o.schema_id = u.schema_id AND 
u.name = @ObjectOwner AND  
o.name = @ObjectName
-- 11/2/2010 5:49:26 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
-- @ObjectOwner:dbo
-- @ObjectName:patient
/*
Specific to SQL Server 2005.
Used for IndexColumnsInfoTrl class
 
The purpose of this script is to get object type information.
*/

use atoregistry;

SELECT o.type AS [Type],
CAST(OBJECTPROPERTY(o.object_id, N'IsMSShipped') AS bit) AS [IsSystemObject]
FROM sys.all_objects o, sys.schemas u 
WHERE o.schema_id = u.schema_id AND 
u.name = @ObjectOwner AND  
o.name = @ObjectName
-- 11/2/2010 5:49:26 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
-- @ObjectOwner:dbo
-- @ObjectName:doctor
/*
Specific to SQL Server 2005.
Used for IndexColumnsInfoTrl class
 
The purpose of this script is to get object type information.
*/

use atoregistry;

SELECT o.type AS [Type],
CAST(OBJECTPROPERTY(o.object_id, N'IsMSShipped') AS bit) AS [IsSystemObject]
FROM sys.all_objects o, sys.schemas u 
WHERE o.schema_id = u.schema_id AND 
u.name = @ObjectOwner AND  
o.name = @ObjectName
-- 11/2/2010 5:49:26 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
-- @ObjectOwner:dbo
-- @ObjectName:structured_items_and_answers
/*
Specific to SQL Server 2005.
Used for IndexColumnsInfoTrl class
 
The purpose of this script is to get object type information.
*/

use atoregistry;

SELECT o.type AS [Type],
CAST(OBJECTPROPERTY(o.object_id, N'IsMSShipped') AS bit) AS [IsSystemObject]
FROM sys.all_objects o, sys.schemas u 
WHERE o.schema_id = u.schema_id AND 
u.name = @ObjectOwner AND  
o.name = @ObjectName
-- 11/2/2010 5:49:26 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers
-- 11/2/2010 5:49:26 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers
-- 11/2/2010 5:49:26 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers
-- 11/2/2010 5:49:27 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
	, structured_items_and_answers.outcome_response
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers
-- 11/2/2010 5:49:29 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers
-- 11/2/2010 5:49:30 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
	, COUNT(structured_items_and_answers.outcome_response) AS response_count
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers
-- 11/2/2010 5:49:30 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
	, COUNT(structured_items_and_answers.outcome_response) AS response_count
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers  
GROUP BY structured_items_and_answers.patient_id
-- 11/2/2010 5:49:30 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
	, COUNT(structured_items_and_answers.outcome_response) AS response_count
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers  
GROUP BY structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
-- 11/2/2010 5:49:30 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
SELECT  structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
	, COUNT(structured_items_and_answers.outcome_response) AS response_count
FROM atoregistry.dbo.structured_items_and_answers structured_items_and_answers  
GROUP BY structured_items_and_answers.patient_id
	, structured_items_and_answers.enc_date
	, structured_items_and_answers.outcome_instr_name
-- 11/2/2010 5:49:39 PM: Execution trace: ROASQL2K8 atoregistry SPID 101: Executed on SPID 101: 
-- Specific to SQL Server 2005.
-- Used in DatabaseListTrl

-- This SQL file contains some Toad specific syntax. 

SET NOCOUNT ON;

SELECT
   
  sd.name as [Name],
  ISNULL(SUSER_SNAME(sd.owner_sid), N'') as [Owner], 
  CAST(HAS_DBACCESS(sd.name) AS bit) as [HasAccess],
  ISNULL(CAST(DATABASEPROPERTYEX(sd.name, 'Status') AS nvarchar(128)), N'') as [Status],
  CAST(sd.is_in_standby AS bit) as [InStandBy],
  sd.user_access_desc as [AccessMode],
  CAST(sd.is_read_only AS bit) as [ReadOnly],
  CAST(CASE
         WHEN sd.name IN ('master', 'model', 'msdb', 'tempdb')
         THEN 1
         ELSE 0
       END AS bit) as [IsSystemDatabase],
  NULL as [LastBackupDate]
   
FROM
  sys.databases sd 
   WHERE ((sd.name <> 'master' AND sd.name <> 'model' AND sd.name <> 'tempdb' AND sd.name <> 'msdb'))
 
ORDER BY
  [Name] ASC
 

-- 11/2/2010 5:49:39 PM: Execution trace: ROASQL2K8 atoregistry SPID : Opened new connection with SPID  (00:00:00)