1. master database - the sys... tables, and in each database the sys...
2. isqlw or isql or the question mark button on Enterprise Manager
3. sp_help <name of table>
3. No separate storage that you can access - it's a column with the
latest values in a bitmap for each table defined with the IDENTITY
The master database contains system catalogs about the entire
installation. Then each database contains its own set of system
catalogs for the contents of its own database. A database in SQL Server
is close to the concept of a schema in Oracle.
There are a set of system stored procedures that help. sp_help in any
database shows the contents and owners of the objects in that database.
sp_help <object_name> give details info on that object. sp_helpsql
<command> give syntax/usage for the command or system stored procedure.
sp_helptext <procedure name> gives the actual text of the stored
Master database contains all LOGINS in syslogins. Then each database
contains a sysusers tables which lists the users and their corresponding
LOGIN in the master database. sp_addlogin <LOGINID>, <PASSWORD>,
<DEFAULT DATABASE> creates a new login. sp_adduser <USERNAME>,
<LOGINID>, <GROUP> within a database creates a user in that database.
sp_addgroup <GROUPNAME> within a database creates that group.
System functions that are useful: object_name(id), db_name(),
getdate(), convert() - check out all the date functions too.
To monitor current activity: sp_who, sp_who2, sp_lock, sp_lock2.
These are just the basics. Hope it helps. There is a system catalog
map that ships with the product. Also you can look up everything in the
books on line which I find very helpful and still use after 7 years in
the field. Books on line lists all system catalogs and the purpose of
each at the column level. www.microsoft.com also has the Knowledge Base
on MSDN Online - lots of articles, bug reports, whitepapers.
> Sorry if these are really basic questions but I am trying to do some
> basic MS-SQL server things and don't quite know where to begin.....
> If there is a website with the MS-SQL server structure, that would be
> helpful too.
> Oracle-isms that I cant find in SQL server...
> ...what are the SQL Server equivalents....
> 1. System Tables and default synonyms....
> OBJECT, ALL_TABLES, etc.
> 2. A simple SQL client like SQLplus.
> 3. DESC in SQLplus.
> 4. Sequences (I think I've seen a 'serial' datatype for columns in SQL
> Any direct answers would be helpful. Any resource that helps an Oracle
> user learn SQL server would be helpful.
> David Black
> Sr.Application Developer
> Nortel Networks