|
|
-
Krishnrajsinh Rana Liked 5 Months ago through Blogs
When you drop a SQL Server database, associated SQL Server Agent jobs are not dropped with it. Presenting a simple query that can be used to identify SQL Server Agent jobs that used to be targeted to a database, but the database no longer exists....
|
-
Krishnrajsinh Rana learned 5 Months ago through Blogs
When you drop a SQL Server database, associated SQL Server Agent jobs are not dropped with it. Presenting a simple query that can be used to identify SQL Server Agent jobs that used to be targeted to a database, but the database no longer exists....
|
|
|
|
|
|
|
-
Krishnrajsinh Rana Commented 6 Months ago through Ask
You can refer below link.
[http://beyondrelational.com/modules/2/blogs/28/posts/10399/tsql-lab-9-how-to-find-the-dependency-chain-of-a-database-object.aspx][1]
[1]: http://beyondrelational.com/modules/2/blogs/28/posts/10399/tsql-lab-9-how-to-f...
|
-
Krishnrajsinh Rana Liked 6 Months ago through Blogs
One of my colleague needed a piece of code that returns all the dependent objects of a given database object. His project has a separate reporting server to which the data from primary database is replicated. He creates the database objects needed for t...
|
-
Krishnrajsinh Rana learned 6 Months ago through Blogs
One of my colleague needed a piece of code that returns all the dependent objects of a given database object. His project has a separate reporting server to which the data from primary database is replicated. He creates the database objects needed for t...
|
-
Krishnrajsinh Rana Liked 7 Months ago through Blogs
A little while ago I thought about putting together my own ERD for the DMVs and System Views. Everyone in the world of relational databases knows how important and useful such diagrams are, and in the (apparent) absence of a Microsoft one, after m...
|
-
Krishnrajsinh Rana learned 7 Months ago through Blogs
A little while ago I thought about putting together my own ERD for the DMVs and System Views. Everyone in the world of relational databases knows how important and useful such diagrams are, and in the (apparent) absence of a Microsoft one, after m...
|