[2024-02-15 09:41:54.

699] [000000] [Desarrollo]

01000 - Changed database context to 'master'.
01000 - Changed language setting to us_english.

[2024-02-15 09:41:54.700] [000000] [Desarrollo]

SELECT @@SPID

[2024-02-15 09:41:54.703] [000072] [Desarrollo]

SET DATEFORMAT ymd

[2024-02-15 09:41:54.708] [000072] [Desarrollo]

SELECT CAST(SERVERPROPERTY('ProductLevel') AS NVARCHAR(4000)) ProductLevel,
CAST(SERVERPROPERTY('Edition') AS NVARCHAR(4000)) AS Edition,
CAST(SERVERPROPERTY('EngineEdition') AS NVARCHAR(4000)) AS EngineEdition

[2024-02-15 09:41:54.710] [000072] [Desarrollo]

SELECT d.name db_name, d.database_id, d.state, d.user_access, d.is_read_only FROM
sys.databases d

[2024-02-15 09:41:56.650] [000000] [Desarrollo]

01000 - Changed database context to 'SIGH'.
01000 - Changed language setting to us_english.

[2024-02-15 09:41:56.650] [000000] [Desarrollo]

SELECT @@SPID

[2024-02-15 09:41:56.652] [000073] [Desarrollo]

SET DATEFORMAT ymd

[2024-02-15 09:41:56.654] [000073] [Desarrollo]

SELECT default_schema_name FROM sys.database_principals WHERE type = 'S' AND
name=USER_NAME()

[2024-02-15 09:41:56.691] [000073] [Desarrollo]

SELECT s.name, USER_NAME(s.principal_id) AS owner, CAST(ep.value AS NVARCHAR(MAX))
AS description FROM sys.schemas s LEFT JOIN sys.extended_properties ep ON
ep.major_id = s.schema_id AND ep.minor_id = 0 AND ep.name = 'MS_Description'

[2024-02-15 09:41:57.596] [000073] [Desarrollo]

SELECT o.object_id, o.name, o.type, o.create_date, o.modify_date,
t.lock_escalation, CAST(ep.value AS NVARCHAR(MAX)) comment,
ct.is_track_columns_updated_on, st.row_count FROM sys.all_objects o LEFT JOIN
sys.schemas s ON o.schema_id = s.schema_id LEFT JOIN sys.tables t ON o.object_id =
t.object_id LEFT JOIN sys.extended_properties ep ON (o.object_id = ep.major_id AND
ep.class = 1 AND ep.minor_id = 0 AND ep.name = 'MS_Description') LEFT JOIN (SELECT
object_id, SUM(ROWS) row_count FROM sys.partitions WHERE index_id < 2 GROUP BY
object_id) st ON o.object_id = st.object_id LEFT JOIN sys.change_tracking_tables ct
ON o.object_id = ct.object_id WHERE s.name = N'guest' AND (o.type='U' OR
o.type='S') ORDER BY o.name

[2024-02-15 09:41:58.260] [000073] [Desarrollo]

SELECT o.object_id, o.name, o.type, o.create_date, o.modify_date,
t.lock_escalation, CAST(ep.value AS NVARCHAR(MAX)) comment,
ct.is_track_columns_updated_on, st.row_count FROM sys.all_objects o LEFT JOIN
sys.schemas s ON o.schema_id = s.schema_id LEFT JOIN sys.tables t ON o.object_id =
t.object_id LEFT JOIN sys.extended_properties ep ON (o.object_id = ep.major_id AND
ep.class = 1 AND ep.minor_id = 0 AND ep.name = 'MS_Description') LEFT JOIN (SELECT
object_id, SUM(ROWS) row_count FROM sys.partitions WHERE index_id < 2 GROUP BY
object_id) st ON o.object_id = st.object_id LEFT JOIN sys.change_tracking_tables ct
ON o.object_id = ct.object_id WHERE s.name = N'dbo' AND (o.type='U' OR o.type='S')
ORDER BY o.name

[2024-02-15 09:48:38.258] [000073] [Desarrollo]

SELECT ao.object_id AS oid, ao.name, ao.type, ao.create_date, ao.modify_date,
CAST(CASE WHEN ao.is_ms_shipped = 1 THEN 1 WHEN (SELECT major_id FROM
sys.extended_properties WHERE major_id = ao.object_id AND minor_id = 0 AND class =
1 AND name = 'microsoft_database_tools_support') IS NOT NULL THEN 1 ELSE 0 END AS
bit) AS is_system_object, CAST(ep.value AS NVARCHAR(MAX)) AS description, dp.name
AS principal, sc.encrypted, NULL AS number, NULL AS source, asm.uses_ansi_nulls,
asm.uses_quoted_identifier, asm.is_schema_bound, asm.uses_database_collation,
asm.is_recompiled, asm.null_on_null_input, p.is_auto_executed,
p.is_execution_replicated, p.is_repl_serializable_only, p.skips_repl_constraints,
dp2.name AS execute_as, NULL AS assembly, NULL AS assembly_class, NULL AS
assembly_method FROM sys.all_objects ao INNER JOIN sys.all_sql_modules asm ON
asm.object_id = ao.object_id INNER JOIN sys.syscomments sc ON sc.id = ao.object_id
AND sc.colid = 1 AND sc.number <= 1 LEFT JOIN sys.procedures p ON p.object_id =
ao.object_id LEFT JOIN sys.database_principals dp ON dp.principal_id =
ao.principal_id LEFT JOIN sys.database_principals dp2 ON dp2.principal_id =
asm.execute_as_principal_id LEFT JOIN sys.extended_properties ep ON ep.major_id =
ao.object_id AND ep.minor_id = 0 AND ep.name = 'MS_Description' WHERE ao.type IN
('P', 'RF', 'FN', 'IF', 'TF') AND ao.schema_id = SCHEMA_ID(N'dbo') UNION ALL
SELECT ao.object_id AS oid, ao.name, NULL AS type, NULL AS create_date, NULL AS
modify_date, NULL AS is_system_object, NULL AS description, NULL AS principal,
sc.encrypted, np.procedure_number AS number, NULL AS source, NULL AS
uses_ansi_nulls, NULL AS uses_quoted_identifier, NULL AS is_schema_bound, NULL AS
uses_database_collation, NULL AS is_recompiled, NULL AS null_on_null_input, NULL AS
is_auto_executed, NULL AS is_execution_replicated, NULL AS
is_repl_serializable_only, NULL AS skips_repl_constraints, NULL AS execute_as, NULL
AS assembly, NULL AS assembly_class, NULL AS assembly_method FROM sys.all_objects
ao INNER JOIN sys.numbered_procedures np ON np.object_id = ao.object_id INNER JOIN
sys.syscomments sc ON sc.id = ao.object_id AND sc.colid = 1 AND sc.number =
np.procedure_number WHERE ao.type = 'P' AND ao.schema_id = SCHEMA_ID(N'dbo') UNION
ALL SELECT ao.object_id AS oid, ao.name, ao.type, ao.create_date, ao.modify_date,
CAST(CASE WHEN ao.is_ms_shipped = 1 THEN 1 WHEN (SELECT major_id FROM
sys.extended_properties WHERE major_id = ao.object_id AND minor_id = 0 AND class =
1 AND name = 'microsoft_database_tools_support') IS NOT NULL THEN 1 ELSE 0 END AS
bit) AS is_system_object, CAST(ep.value AS NVARCHAR(MAX)) AS description, dp.name
AS principal, 0 AS encrypted, NULL AS number, NULL AS source, NULL AS
uses_ansi_nulls, NULL AS uses_quoted_identifier, NULL AS is_schema_bound, NULL AS
uses_database_collation, NULL AS is_recompiled, am.null_on_null_input, NULL AS
is_auto_executed, NULL AS is_execution_replicated, NULL AS
is_repl_serializable_only, NULL AS skips_repl_constraints, dp2.name AS execute_as,
a.name AS assembly, am.assembly_class, am.assembly_method FROM sys.all_objects ao
INNER JOIN sys.assembly_modules am ON am.object_id = ao.object_id INNER JOIN
sys.assemblies a ON a.assembly_id = am.assembly_id LEFT JOIN
sys.database_principals dp ON dp.principal_id = ao.principal_id LEFT JOIN
sys.database_principals dp2 ON dp2.principal_id = am.execute_as_principal_id LEFT
JOIN sys.extended_properties ep ON ep.major_id = ao.object_id AND ep.minor_id = 0
AND ep.name = 'MS_Description' WHERE ao.type IN ('PC', 'FS', 'FT') AND ao.schema_id
= SCHEMA_ID(N'dbo')

[2024-02-15 09:48:39.522] [000073] [Desarrollo]

SELECT ao.name, 1 AS number, p.parameter_id, p.name AS paramname,
SCHEMA_NAME(t.schema_id) AS typeschema, t.name AS typename, p.max_length,
p.precision, p.scale, p.is_cursor_ref, p.is_output, p.is_readonly,
p.has_default_value, p.default_value FROM sys.all_parameters p INNER JOIN sys.types
t ON p.user_type_id = t.user_type_id INNER JOIN sys.all_objects ao ON p.object_id =
ao.object_id WHERE ao.type IN ('P', 'RF', 'PC', 'FN', 'IF', 'TF', 'FS', 'FT') AND
ao.schema_id = SCHEMA_ID(N'dbo') AND (p.parameter_id > 0 OR ao.type = 'FS') UNION
ALL SELECT ao.name, np.procedure_number AS number, np.parameter_id, np.name AS
paramname, SCHEMA_NAME(t.schema_id) AS typeschema, t.name AS typename,
np.max_length, np.precision, np.scale, np.is_cursor_ref, np.is_output, 0 AS
is_readonly, 0 AS has_default_value, NULL AS default_value FROM
sys.numbered_procedure_parameters np INNER JOIN sys.types t ON np.user_type_id =
t.user_type_id INNER JOIN sys.all_objects ao ON np.object_id = ao.object_id WHERE
ao.schema_id = SCHEMA_ID(N'dbo') ORDER BY ao.name, number, parameter_id

[2024-02-15 09:48:40.535] [000073] [Desarrollo]

SELECT ao.name, ac.name AS colname, ac.column_id, ac.object_id, t.name AS typename,
SCHEMA_NAME(t.schema_id) AS typeschema, ac.max_length, ac.precision, ac.scale ,
foc.order_column_id, foc.is_descending FROM sys.all_columns ac INNER JOIN
sys.types t ON ac.user_type_id = t.user_type_id INNER JOIN sys.all_objects ao ON
ac.object_id = ao.object_id LEFT JOIN sys.function_order_columns foc ON
ac.object_id = foc.object_id AND ac.column_id = foc.column_id WHERE ao.type = 'FT'
AND ao.schema_id = SCHEMA_ID(N'dbo') ORDER BY ac.column_id

[2024-02-15 09:48:46.424] [000072] [Desarrollo]

SELECT p.name, p.principal_id, p.type, p.is_disabled, p.create_date, p.modify_date,
p.default_database_name, p.default_language_name, lan.alias AS
default_language_alias, LOGINPROPERTY(p.name, 'IsLocked') AS is_locked,
LOGINPROPERTY(p.name, 'IsExpired') AS is_expired, LOGINPROPERTY(p.name,
'IsMustChange') AS is_must_changed, l.is_policy_checked, l.is_expiration_checked,
cert.name AS certificate, ak.name AS asymmkey FROM sys.server_principals p LEFT
OUTER JOIN sys.sql_logins l ON l.principal_id = p.principal_id LEFT OUTER JOIN
master.sys.certificates cert ON p.sid = cert.sid LEFT OUTER JOIN
master.sys.asymmetric_keys ak ON p.sid = ak.sid LEFT OUTER JOIN sys.syslanguages
lan ON lan.name = p.default_language_name WHERE (p.type = 'S' OR p.type = 'U' OR
p.type = 'G' OR p.type = 'C' OR p.type = 'K')

[2024-02-15 09:48:46.479] [000072] [Desarrollo]

SELECT p.name, cre.name AS credential FROM sys.server_principal_credentials pc
INNER JOIN sys.credentials cre ON pc.credential_id = cre.credential_id INNER JOIN
sys.server_principals p ON pc.principal_id = p.principal_id

[2024-02-15 09:48:46.486] [000072] [Desarrollo]

SELECT name, principal_id, create_date, modify_date FROM sys.server_principals
WHERE type='R'

[2024-02-15 09:48:46.493] [000073] [Desarrollo]

SELECT t.name AS typename, u.name AS schemaname FROM sys.types t INNER JOIN
sys.schemas u ON u.schema_id = t.schema_id ORDER BY t.name, u.name

[2024-02-15 09:48:46.528] [000073] [Desarrollo]

SELECT ao.object_id AS oid, ao.name, ao.type, ao.create_date, ao.modify_date,
CAST(CASE WHEN ao.is_ms_shipped = 1 THEN 1 WHEN (SELECT major_id FROM
sys.extended_properties WHERE major_id = ao.object_id AND minor_id = 0 AND class =
1 AND name = 'microsoft_database_tools_support') IS NOT NULL THEN 1 ELSE 0 END AS
bit) AS is_system_object, CAST(ep.value AS NVARCHAR(MAX)) AS description, dp.name
AS principal, sc.encrypted, NULL AS number, asm.definition AS source,
asm.uses_ansi_nulls, asm.uses_quoted_identifier, asm.is_schema_bound,
asm.uses_database_collation, asm.is_recompiled, asm.null_on_null_input,
p.is_auto_executed, p.is_execution_replicated, p.is_repl_serializable_only,
p.skips_repl_constraints, dp2.name AS execute_as, NULL AS assembly, NULL AS
assembly_class, NULL AS assembly_method FROM sys.all_objects ao INNER JOIN
sys.all_sql_modules asm ON asm.object_id = ao.object_id INNER JOIN sys.syscomments
sc ON sc.id = ao.object_id AND sc.colid = 1 AND sc.number <= 1 LEFT JOIN
sys.procedures p ON p.object_id = ao.object_id LEFT JOIN sys.database_principals dp
ON dp.principal_id = ao.principal_id LEFT JOIN sys.database_principals dp2 ON
dp2.principal_id = asm.execute_as_principal_id LEFT JOIN sys.extended_properties ep
ON ep.major_id = ao.object_id AND ep.minor_id = 0 AND ep.name = 'MS_Description'
WHERE ao.type IN ('P', 'RF', 'FN', 'IF', 'TF') AND ao.schema_id = SCHEMA_ID(N'dbo')
AND ao.name = N'CajaGestionAgregar' UNION ALL SELECT ao.object_id AS oid, ao.name,
NULL AS type, NULL AS create_date, NULL AS modify_date, NULL AS is_system_object,
NULL AS description, NULL AS principal, sc.encrypted, np.procedure_number AS
number, np.definition AS source, NULL AS uses_ansi_nulls, NULL AS
uses_quoted_identifier, NULL AS is_schema_bound, NULL AS uses_database_collation,
NULL AS is_recompiled, NULL AS null_on_null_input, NULL AS is_auto_executed, NULL
AS is_execution_replicated, NULL AS is_repl_serializable_only, NULL AS
skips_repl_constraints, NULL AS execute_as, NULL AS assembly, NULL AS
assembly_class, NULL AS assembly_method FROM sys.all_objects ao INNER JOIN
sys.numbered_procedures np ON np.object_id = ao.object_id INNER JOIN
sys.syscomments sc ON sc.id = ao.object_id AND sc.colid = 1 AND sc.number =
np.procedure_number WHERE ao.type = 'P' AND ao.schema_id = SCHEMA_ID(N'dbo') AND
ao.name = N'CajaGestionAgregar' AND np.procedure_number = 1 UNION ALL SELECT
ao.object_id AS oid, ao.name, ao.type, ao.create_date, ao.modify_date, CAST(CASE
WHEN ao.is_ms_shipped = 1 THEN 1 WHEN (SELECT major_id FROM sys.extended_properties
WHERE major_id = ao.object_id AND minor_id = 0 AND class = 1 AND name =
'microsoft_database_tools_support') IS NOT NULL THEN 1 ELSE 0 END AS bit) AS
is_system_object, CAST(ep.value AS NVARCHAR(MAX)) AS description, dp.name AS
principal, 0 AS encrypted, NULL AS number, NULL AS source, NULL AS uses_ansi_nulls,
NULL AS uses_quoted_identifier, NULL AS is_schema_bound, NULL AS
uses_database_collation, NULL AS is_recompiled, am.null_on_null_input, NULL AS
is_auto_executed, NULL AS is_execution_replicated, NULL AS
is_repl_serializable_only, NULL AS skips_repl_constraints, dp2.name AS execute_as,
a.name AS assembly, am.assembly_class, am.assembly_method FROM sys.all_objects ao
INNER JOIN sys.assembly_modules am ON am.object_id = ao.object_id INNER JOIN
sys.assemblies a ON a.assembly_id = am.assembly_id LEFT JOIN
sys.database_principals dp ON dp.principal_id = ao.principal_id LEFT JOIN
sys.database_principals dp2 ON dp2.principal_id = am.execute_as_principal_id LEFT
JOIN sys.extended_properties ep ON ep.major_id = ao.object_id AND ep.minor_id = 0
AND ep.name = 'MS_Description' WHERE ao.type IN ('PC', 'FS', 'FT') AND ao.schema_id
= SCHEMA_ID(N'dbo') AND ao.name = N'CajaGestionAgregar'

[2024-02-15 09:48:46.676] [000073] [Desarrollo]

SELECT ao.name, 1 AS number, p.parameter_id, p.name AS paramname,
SCHEMA_NAME(t.schema_id) AS typeschema, t.name AS typename, p.max_length,
p.precision, p.scale, p.is_cursor_ref, p.is_output, p.is_readonly,
p.has_default_value, p.default_value FROM sys.all_parameters p INNER JOIN sys.types
t ON p.user_type_id = t.user_type_id INNER JOIN sys.all_objects ao ON p.object_id =
ao.object_id WHERE ao.type IN ('P', 'RF', 'PC', 'FN', 'IF', 'TF', 'FS', 'FT') AND
ao.schema_id = SCHEMA_ID(N'dbo') AND ao.name = N'CajaGestionAgregar' AND
(p.parameter_id > 0 OR ao.type = 'FS') UNION ALL SELECT ao.name,
np.procedure_number AS number, np.parameter_id, np.name AS paramname,
SCHEMA_NAME(t.schema_id) AS typeschema, t.name AS typename, np.max_length,
np.precision, np.scale, np.is_cursor_ref, np.is_output, 0 AS is_readonly, 0 AS
has_default_value, NULL AS default_value FROM sys.numbered_procedure_parameters np
INNER JOIN sys.types t ON np.user_type_id = t.user_type_id INNER JOIN
sys.all_objects ao ON np.object_id = ao.object_id WHERE ao.schema_id =
SCHEMA_ID(N'dbo') AND ao.name = N'CajaGestionAgregar' AND np.procedure_number = 1
ORDER BY ao.name, number, parameter_id

[2024-02-15 09:48:46.716] [000073] [Desarrollo]

SELECT ao.name, ac.name AS colname, ac.column_id, ac.object_id, t.name AS typename,
SCHEMA_NAME(t.schema_id) AS typeschema, ac.max_length, ac.precision, ac.scale ,
foc.order_column_id, foc.is_descending FROM sys.all_columns ac INNER JOIN
sys.types t ON ac.user_type_id = t.user_type_id INNER JOIN sys.all_objects ao ON
ac.object_id = ao.object_id LEFT JOIN sys.function_order_columns foc ON
ac.object_id = foc.object_id AND ac.column_id = foc.column_id WHERE ao.type = 'FT'
AND ao.schema_id = SCHEMA_ID(N'dbo') AND ao.name = N'CajaGestionAgregar' ORDER BY
ac.column_id

[2024-02-15 09:48:46.763] [000000] [Desarrollo]

01000 - Changed database context to 'SIGH'.
01000 - Changed language setting to us_english.

[2024-02-15 09:48:46.838] [000000] [Desarrollo]

SELECT @@SPID

[2024-02-15 09:48:46.839] [000062] [Desarrollo]

SET DATEFORMAT ymd

[2024-02-15 09:48:46.840] [000062] [Desarrollo]

SELECT name FROM [SIGH].sys.schemas ORDER BY name

[2024-02-15 09:48:46.842] [000062] [Desarrollo]

SELECT default_schema_name FROM sys.database_principals WHERE type = 'S' AND
name=USER_NAME()

[2024-02-15 09:48:46.847] [000062] [Desarrollo]

SELECT o.name FROM [SIGH].sys.objects o INNER JOIN [SIGH].sys.schemas s ON
o.schema_id = s.schema_id WHERE s.name = N'dbo' AND (type='U' OR type='S') ORDER BY
o.name

[2024-02-15 09:48:46.861] [000062] [Desarrollo]

SELECT v.name FROM [SIGH].sys.all_views v INNER JOIN [SIGH].sys.schemas s ON
v.schema_id = s.schema_id WHERE s.name = N'dbo' ORDER BY v.name

[2024-02-15 09:48:46.869] [000062] [Desarrollo]

(SELECT o.name as name, 1 as number FROM [SIGH].sys.all_objects o INNER JOIN
[SIGH].sys.schemas s ON o.schema_id = s.schema_id WHERE type IN ('P', 'PC', 'RF')
AND s.name = N'dbo' UNION SELECT ao.name as name, np.procedure_number as number
FROM [SIGH].sys.all_objects ao INNER JOIN [SIGH].sys.schemas ss ON ao.schema_id =
ss.schema_id INNER JOIN [SIGH].sys.numbered_procedures np ON np.object_id =
ao.object_id WHERE type = 'P' AND ss.name = N'dbo') ORDER BY name, number

[2024-02-15 09:48:46.933] [000062] [Desarrollo]

SELECT o.name FROM [SIGH].sys.all_objects o INNER JOIN [SIGH].sys.schemas s ON
o.schema_id = s.schema_id WHERE type IN ('FN','FS','FT','IF','TF') AND s.name =
N'dbo' ORDER BY o.name

[2024-02-15 09:48:46.941] [000062] [Desarrollo]

SELECT default_schema_name FROM sys.database_principals WHERE type = 'S' AND
name=USER_NAME()