|
|
-
Manas Ranjan Dash Learned 1 Years ago through Just Learned | 1 Point
I stumbled across a scenario where I had to find all the triggers associated with few tables. Found the below queries and felt that they are worth sharing. I am listing the helpful sql queries!
To get a list of all the triggers in the database
...
|
-
Manas Ranjan Dash Liked 1 Years ago through Just Learned | 1 Point
I stumbled across a scenario where I had to find all the triggers associated with few tables. Found the below queries and felt that they are worth sharing. I am listing the helpful sql queries!
To get a list of all the triggers in the database
...
|
-
Manas Ranjan Dash Learned 1 Years ago through Just Learned | 1 Point
I stumbled across a scenario where I had to find all the triggers associated with few tables. Found the below queries and felt that they are worth sharing. I am listing the helpful sql queries!
To get a list of all the triggers in the database
...
|
-
Manas Ranjan Dash Liked 1 Years ago through Just Learned | 1 Point
Today, while doing query or performance analysis, I wanted to start a profiler trace on the sql server in question. But since profiler generates network traffic I was looking for another approach. I learned that we can start the trace using system st...
|
-
Manas Ranjan Dash Learned 1 Years ago through Just Learned | 1 Point
Today, while doing query or performance analysis, I wanted to start a profiler trace on the sql server in question. But since profiler generates network traffic I was looking for another approach. I learned that we can start the trace using system st...
|
-
Manas Ranjan Dash Liked 1 Years ago through Just Learned | 1 Point
Today, while doing query or performance analysis, I wanted to start a profiler trace on the sql server in question. But since profiler generates network traffic I was looking for another approach. I learned that we can start the trace using system st...
|
-
Manas Ranjan Dash Learned 1 Years ago through Just Learned | 1 Point
Today, while doing query or performance analysis, I wanted to start a profiler trace on the sql server in question. But since profiler generates network traffic I was looking for another approach. I learned that we can start the trace using system st...
|
-
Manas Ranjan Dash Liked 1 Years ago through Just Learned | 1 Point
It is because sp_helptext may not return the correct procedure name as it returns text from syscomments system table. When a procedure is renamed using sp_rename, the text column of this table is not updated.
Consider this example
[code]
create proce...
|
-
Manas Ranjan Dash Learned 1 Years ago through Just Learned | 1 Point
It is because sp_helptext may not return the correct procedure name as it returns text from syscomments system table. When a procedure is renamed using sp_rename, the text column of this table is not updated.
Consider this example
[code]
create proce...
|
-
Manas Ranjan Dash Liked 1 Years ago through Just Learned | 1 Point
It is because sp_helptext may not return the correct procedure name as it returns text from syscomments system table. When a procedure is renamed using sp_rename, the text column of this table is not updated.
Consider this example
[code]
create proce...
|