1) How many rows any view can hold in SQL server 2000? 2) How can i create a view which holds data of a remote machine?
1) Books online states quote: A view can be thought of as either a virtual table or a stored query. The data accessible through a view is not stored in the database as a distinct object. A view is used to do any or all of these functions: Restrict a user to specific rows in a table. For example, allow an employee to see only the rows recording his or her work in a labor-tracking table. Restrict a user to specific columns. For example, allow employees who do not work in payroll to see the name, office, work phone, and department columns in an employee table, but do not allow them to see any columns with salary information or personal information. Join columns from multiple tables so that they look like a single table. Aggregate information instead of supplying details. For example, present the sum of a column, or the maximum or minimum value from a column. 2) Refer to the books online again for 'Views' & Linked servers sections for more information. Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided AS IS with no rights for the sake of knowledge sharing.
Refer Books On Line for all your general questions. Also make use of Google Madhivanan Failing to plan is Planning to fail
