 |
| |
Labs4IT! The Ultimate IT Training Centre
Labs4IT.com is the ultimate IT training centre in the Information Technology world. We provide the helpful and highly appreciated online IT training in the form of visual interactive learning demos. These training demos are categorized according to Vendor's products like Microsoft Windows XP Professional, Microsoft Windows 2000/2003 Server, Microsoft ISA Server, and Microsoft Exchange Server etc. These online demos will provide you the interactive training for above mentioned products in such a highly expertize environment that you will not forget to configure even a complex configuration on the Microsoft products. You can run our free samples of online demos.
This site is updated on the daily basis and we continuously add the new demos in our collections. At this time, we have the hundreds of training demos for different products. You can check the archive of these online demos at our Demos Archive Page.
You can freely register at our site. After registration and then subscribing to our site on monthly or quarterly basis, you are free to run these hundreds of demos to extend your IT knowledge and to qualify for any Microsoft IT certification like MCSE, MCSA, MCAD, or MCSD.
|
|
Please subscribe here on quarterly basis to run the demos. You will be charged only 15 USD for three months. After subscribing through paypal, you are free to run hundreds of demos for learning purposes.
PLEASE LOGIN!
|
|
|
How to Delete a View in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Delete a View in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of deleting a view in Microsoft SQL Server 2000. After a view has been created, you can delete the view if it is not needed, or if you want to clear the view definition and the permissions associated with it. When a view is deleted, the tables and the data upon which it is based are not affected. Any queries that use objects that depend on the deleted view fail when they are next executed, unless a view with the same name is created. However, if the new view does not reference objects expected by any objects dependent on the new view, queries using the dependent objects fail when executed.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Friday, March 24 @ 00:20:01 EST
(Read More... | Score: 0)
|
|
|
How to Display the Dependencies of a View in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Display the Dependencies of a View in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of displaying the dependencies of a view in Microsoft SQL Server 2000. Views are queried the same way that ordinary tables are queried. However, any table hints used when querying the view are ignored. If you change the name of an object referenced by a view, you must modify the view so that its text reflects the new name. Therefore, before renaming an object, display the dependencies of the object first to determine if any views are affected by the proposed change.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Wednesday, March 22 @ 00:42:26 EST
(Read More... | Score: 0)
|
|
|
How to Get Information About a View in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Get Information About a View in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of getting information about a view in Microsoft SQL Server 2000. You can gain information about the definition of a view if it is not encrypted. You may need to see the definition of the view to understand how its data is derived from the source tables or to see the data defined by the view. Views are queried the same way that ordinary tables are queried. However, any table hints used when querying the view are ignored.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Tuesday, March 21 @ 06:37:13 EST
(Read More... | Score: 0)
|
|
|
How to Rename a View in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Rename a View in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of renaming a view in Microsoft SQL Server 2000. After a view is defined, you can change its name or modify its definition without dropping and re-creating the view, thereby losing the permissions associated with the view. Altering a view does not affect any dependent objects, such as stored procedures or triggers, unless the definition of the view changes in such a way that the dependent object is no longer valid.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Tuesday, March 21 @ 00:21:39 EST
(Read More... | Score: 0)
|
|
|
How to Create a View Using the Create View Wizard in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Create a View Using the Create View Wizard in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of creating a view using the create view wizard in Microsoft SQL Server 2000. To create a view you must be granted permission to do so by the database owner and you must have appropriate permissions on any tables or views referenced in the view definition.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Monday, March 20 @ 05:57:04 EST
(Read More... | Score: 0)
|
|
|
How to Delete a DEFAULT Object in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Delete a DEFAULT Object in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of deleting a default object in Microsoft SQL Server 2000.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Monday, March 20 @ 01:17:47 EST
(Read More... | Score: 0)
|
|
|
How to Create a DEFAULT Object in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Create a DEFAULT Object in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of creating a default object in Microsoft SQL Server 2000.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Saturday, March 18 @ 05:01:41 EST
(Read More... | Score: 0)
|
|
|
How to Delete User-Defined Data Type in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Delete User-Defined Data Type in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of deleting user-defined data type in Microsoft SQL Server 2000. User-defined data types are based on the system data types in Microsoft SQL Server 2000. User-defined data types can be used when several tables must store the same type of data in a column and you must ensure that these columns have exactly the same data type, length, and nullability.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Saturday, March 18 @ 00:36:05 EST
(Read More... | Score: 0)
|
|
|
How to Create User-Defined Data Types in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Create User-Defined Data Types in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of creating user -defined data types in Microsoft SQL Server 2000. User-defined data types are based on the system data types in Microsoft SQL Server 2000. User-defined data types can be used when several tables must store the same type of data in a column and you must ensure that these columns have exactly the same data type, length, and nullability. For example, a user-defined data type called postal_code could be created based on the char data type.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Friday, March 17 @ 05:36:53 EST
(Read More... | Score: 0)
|
|
|
How to Delete a Database in Microsoft SQL Server 2000
|
|
A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is
Title: How to Delete a Database in Microsoft SQL Server 2000
Objective: The objective of this demo is to teach you the process of deleting a database in Microsoft SQL Server 2000.You can delete a nonsystem database when it is no longer needed or if it is moved to another database or server. When a database is deleted, the files and their data are deleted from the disk on the server. When a database is deleted, it is permanently deleted and cannot be retrieved without using a previous backup. System databases (msdb, master, model, tempdb) cannot be deleted.
If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.
|
Posted on Friday, March 17 @ 00:31:04 EST
(Read More... | Score: 0)
|
|
| |
|
No new demo has been added today.
|
| Thursday, March 16 | | · | How to Start the Database Maintenance Plan Wizard in Microsoft SQL Server 2000 |
| · | How to View a List of Databases on a Microsoft SQL Server 2000 |
| Wednesday, March 15 | | · | How to View the setting for a Database in Microsoft SQL Server 2000 |
| Tuesday, March 14 | | · | How to Change the Configuration Settings for a Database in Microsoft SQL Server 2000 |
| Monday, March 13 | | · | How to Shrink a Database in Microsoft SQL Server 2000 |
| Saturday, March 11 | | · | How to Create a Database Using the Create Database Wizard in Microsoft SQL Server 2000 |
| · | How to Set Trace Display Defaults in Microsoft SQL Server 2000 |
| Friday, March 10 | | · | How to Set Trace Definition Defaults in Microsoft SQL Sever 2000 |
| · | How to View the SQL Server 2000 Error Log |
| Thursday, March 09 | | · | How to Terminate a Process in Microsoft SQL Server 2000 |
| · | How to Send a Message to a Currently Connected User in Microsoft SQL Server 2000 |
| Wednesday, March 08 | | · | How to View the Current Locks in Microsoft SQL Server 2000 |
| · | How to View Current Server Activity in Microsoft SQL Server 2000 |
| Tuesday, March 07 | | · | How to Start SQL Profiler in Microsoft SQL Server 2000 |
| · | How to Grant, Deny, or Revoke Permissions on Multiple Objects to a User-defined Role in Microsoft SQL Server 2000 |
| Monday, March 06 | | · | How to Remove an Application Role in Microsoft SQL Server 2000 |
| · | How to Create an Application Role in Microsoft SQL Server 2000 |
| Saturday, March 04 | | · | How to Revoke Permissions on Multiple Objects from a User, Group, or Role in Microsoft SQL Server 2000 |
| · | How to Revoke Statement Permissions from Users in a Database in Microsoft SQL Server 2000 |
| Thursday, March 02 | | · | How to Revoke Permissions on an Object in Microsoft SQL Server 2000 |
| · | How to Deny Permissions on Multiple Objects to a User, Group, or Role in Microsoft SQL Server 2000 |
| Wednesday, March 01 | | · | How to Deny Statement Permissions from Users within a Database in Microsoft SQL Server 2000 |
| · | How to Prevent Access by Denying Permissions in Microsoft SQL Server 2000 |
| Tuesday, February 28 | | · | How to Grant Permissions on Multiple Objects to a User or Role in Microsoft SQL Server 2000 |
| · | How to Grant Statement Permissions to Users within a Database in Microsoft SQL Server 2000 |
| Monday, February 27 | | · | How to Allow Access by Granting Permissions in Microsoft SQL Server 2000 |
| Saturday, February 25 | | · | How to Remove a SQL Server Role |
| · | How to Remove a Login from a Fixed Server Role in Microsoft SQL Server 2000 |
| · | How to View the Members of a Fixed Server Role in Microsoft SQL Server 2000 |
| Friday, February 24 | | · | How to View the Roles Defined in the Current Database in Microsoft SQL Server 2000 |
Older Demos
|
|
|
Your Account
Demos
News
Misc