|
Home > Archive > microsoft.public.cert.mcdba > February 2003 > System Stored Procedures and 70-229
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
System Stored Procedures and 70-229
|
|
| Michael 2003-02-26, 3:24 pm |
| I'm curious which system stored procedure you view as important and most useful. I'm preparing to retake 70-229, but I'm as interested in which you find useful in working with SQL Server 2000 as I am in which are on the test, so that I can understand thos
e. I mostly design data models and implement them in SQL server, then design applications that access those, so I'm not using SQL Server on as detailed of a level as I'd like.
Anyway, here's the list of system stored procedures: http://msdn.microsoft.com/library/d....asp?frame=true
Thanks,
Michael
| |
|
| <Michael> wrote in message news:uZ7zZdd3CHA.2240@TK2MSFTNGP10.phx.gbl...
> I'm curious which system stored procedure you view as important and most
useful.
I don't use any in production code, but occasionally use a small bunch for
ad hoc work:
sp_who2
sp_lock
sp_renamedb
sp_dboption
sp_configure
sp_help(various objects)
I think that's about it for me. And it's so infrequent that I check books
online any time I have to provide parameters for any of them.
By the way, the link you provided went to a 'Minimizing Deadlocks' page, not
a list of stored procedures.
| |
| Michael 2003-02-26, 5:23 pm |
| oops. Forgot to 'sync toc'. Link should have been: http://msdn.microsoft.com/library/d....asp?frame=true
Thanks, Tim.
[colo
r=darkred]
>>> Tim<spammers@begone> 02/26/03 04:08PM >>>[/color]
<Michael> wrote in message news:uZ7zZdd3CHA.2240@TK2MSFTNGP10.phx.gbl...
> I'm curious which system stored procedure you view as important and most
useful.
I don't use any in production code, but occasionally use a small bunch for
ad hoc work:
sp_who2
sp_lock
sp_renamedb
sp_dboption
sp_configure
sp_help(various objects)
I think that's about it for me. And it's so infrequent that I check books
online any time I have to provide parameters for any of them.
By the way, the link you provided went to a 'Minimizing Deadlocks' page, not
a list of stored procedures.
| |
| rcaine 2003-02-26, 8:34 pm |
| For test purposes the list should include:
sp_addlogin
sp_addsrvrolemember
sp_denylogin
sp_droprole
sp_grantlogin
sp_lock
sp_monitor
sp_revokelogin
sp_spaceused
sp_who |
|
|
|
|