|
|
-
Krishnrajsinh Rana Learned 10 Months ago through Just Learned | 1 Point
I needed to check where all a table is being used in a database or which objects are dependent on a table. Searched google and Pinal was on top :)
Here is the code.
SELECT referencing_schema_name, referencing_entity_name,
referencing_id, r...
|
-
Krishnrajsinh Rana Liked 10 Months ago through Just Learned | 1 Point
I needed to check where all a table is being used in a database or which objects are dependent on a table. Searched google and Pinal was on top :)
Here is the code.
SELECT referencing_schema_name, referencing_entity_name,
referencing_id, r...
|
-
Krishnrajsinh Rana Liked 10 Months ago through Just Learned | 1 Point
I needed to check where all a table is being used in a database or which objects are dependent on a table. Searched google and Pinal was on top :)
Here is the code.
SELECT referencing_schema_name, referencing_entity_name,
referencing_id, r...
|
-
Krishnrajsinh Rana Liked 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Krishnrajsinh Rana Liked 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Krishnrajsinh Rana Learned 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Krishnrajsinh Rana Learned 11 Months ago through Just Learned | 1 Point
"SQL Authority" Pinal Sir published a tip about $rowguid, which can be used to fetch uniqueidentifier column from a table. It was awesome. You can find the link below.
[SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying S...
|
-
Krishnrajsinh Rana Learned 11 Months ago through Just Learned | 1 Point
A simple method to find out who altered/modified an object in SQL server using trace.
SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_i...
|
-
Krishnrajsinh Rana Learned 11 Months ago through Just Learned | 1 Point
A simple method to find out who altered/modified an object in SQL server using trace.
SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_i...
|
-
Krishnrajsinh Rana Liked 11 Months ago through Just Learned | 1 Point
A simple method to find out who altered/modified an object in SQL server using trace.
SELECT I.*
FROM
sys.traces T
CROSS Apply ::fn_trace_gettable(T.path, T.max_files) I
Join sys.trace_events E On I.eventclass = E.trace_event_i...
|