What are SQL Server System Stored Procedures used most?
-
I am reading some books of SQL Server script developments and chapters of System Stored Procedures. The books just mention a long list of such system stored procedures and some examples of them. In practice or the real world of SQL script developments, I'd like to know what the most used SQL Server System Stored Procedures are used most or should be known by SQL scripters/developerd?
Thank in advance.
-
depends on individual and work involved
I used most of the systems sp
-
I, on the other hand, use very few. I tend to not trust mucking about with them. The solutions I come up with may not be the most efficient, but I generally know exactly what they're doing.
Of course, most of my work doesn't require the database to look at itself. So, I very rarely need to reference the metadata.
-
Never given it much thought before, but come to think of it, I'd imagine that developers in general probably don't script/code much against the system procs - they are more of interest for the dba writing maintenance admin scripts and stuff.
But, if you also consider system functions, then I think we're right in developer-land.
(they should know practically all of them
)/Kenneth
-
Everyone probably uses the system SPs more than they realize. The SQL Server application software imakes use of a great many system stored procedures. Service Pack applications as well. Just turn on profiler for a bit and run through EM and see what you can see ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply