Show all tables
select * from information_schema.tables
Show user privilege
1
2
| SELECT * FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES
exec sp_helprotect
|
Change password of sa
1
2
3
| osql -S yourservername -E
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO
|