|
Subject:
|
extra tables in MS-SQL Server
|
|
Posted By:
|
melvik
|
Post Date:
|
7/27/2003 8:19:42 AM
|
Hi there!
I use MS-SQL Server 2000 & C#.NET for my window app.
There are some Stored Procedures in my Database witch I didnt creat them! What are they?! & Why they created!?!?
Always ,
Hovik Melkomian.
|
|
Reply By:
|
bani
|
Reply Date:
|
9/20/2003 12:02:12 PM
|
They are called system procedures and they usually start with "sp" or "xp". Think of them as commands that the good ole folks from SQL Server team created for your comfort. They can be very helpful too.
You can query database details using the sp_helpdb system proc or add a user using the sp_addlogin system proc.
here, try this
exec sp_addlogin 'melvik', 'a_password', 'Northwind'
go
use Northwind
exec sp_grantdbaccess 'melvik'
go
exec sp_revokedbaccess 'melvik'
go
exec sp_droplogin 'melvik'
go
use master
go
exec sp_helpdb 'Northwind
go
see online books for more system/extended procedures
|
