Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Content with tag
System Tables
Items 1 to 3 of 3
Never update systems tables directly - a study in Agent job scheduling
It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.
Read more...
By
Nakul Vachhrajani
2012/09/17
|
Source:
SQLServerCentral.com
|
Category:
sql server agent
Rating:
|
Discuss
|
Briefcase
|
4,228 reads
What is sysprocesses and what can it do for you?
This article presents a description of sysprocesses aimed at the newer DBAs. From new author Edward Elliot, he dives into what you can learn from this system view.
Read more...
By
Edward Elliott
2009/05/01
|
Source:
SQLServerCentral.com
|
Category:
system tables
Rating:
|
Discuss
|
Briefcase
|
13,573 reads
Find a Table's Metadata
Stored Procedure that returns table information
Read more...
By
Crosbie Christopher
2013/05/21
|
Source:
SQLServerCentral.com
|
Category:
stored procedures
Rating:
|
Discuss
|
Briefcase
|
1,276 reads
Items 1 to 3 of 3
Tags
administration
(2)
::fn_listextendedproperty
(1)
best practices
(1)
columns
(1)
dba
(1)
find foreign key using sql
(1)
nightly jobs
(1)
sql server agent
(1)
stored procedures
(1)
table field information
(1)
table metadata
(1)
t-sql
(1)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.