SQL Server 2000 Administration
SQL Server 2000 Administration
Topics for this course
55 Lessons
SQL Server 2000 Administration
01 How to send Mail with CDONTS from SQL Server
02 How to start MS SQL Server 2000
03 How to stop MSSQL Server
04 What is data cube
05 How can I use this features
06 How to set up Data Source for Analysis
07 How to connect DSN to Analysis Manager
08 How to create Data Cube
09 How to create dimension
10 How to set up storage aggregation
11 How to browse Data cube
12 How do I access SQL Server From the Browser
13 How to execute MSSQL Stored Procedure from IIS
14 What is the use of a template
15 How to create Template Access through your Browser
16 How to access your MSSQL Data through template
17 How to create a Stored Procedure
18 How to drop a stored procedure
19 How to create a database
20 How do you specify a custom location for your database
21 How do you specify the location of your transaction log
22 How to extend your Database
23 How to disable Automatic Grow features
24 How to remove Database
25 How to find a list of database available in the system
26 How to detach and attach Database to MSSQL Server
27 How to determine which file to attach
28 How to connect to another SQL Server in your network
29 How to delete the connected Server from your group
30 What are the types of indexing available in MSSQL 2000
31 How to create index in your table
32 How to mange index
33 How to view Indexing within your database
34 How to delete an index
35 What are the different data type available in MS SQL Server
36 How do I use Data Transformation package
37 How to create Tables in SQL Server
38 How to alter a table in MS SQL Server
39 How to alter table to add a new column with T-SQL
40 How to delete a column with T-SQL
41 How to Work with views
42 How to create a view
43 How to create a new user
44 How to assign Database Access to user
45 How to check on current activity
46 How to kill processes
47 How to send a messages to users who’s process might slow down the system
48 How to view MS SQL Logs
49 What is SQL Profiler
50 How do I create a trace statement in SQL Profiler
51 How to add Linked Server to MS SQL Server
52 How do I pass Query to Linked Server
53 What is the difference between a remote server and a linked server
54 How to find the status and information of connected servers in your MSSQL Server
55 How do you select Top 3 records from your database
About the instructor
69 Courses
3 students
Free