-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: Saurabh_Rajderkar
Message 2 in Discussion
New Message on MumbaiUserGroup
.Net Gyan
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
Saurabh_Rajderkar
SQL Server Overview
You have created a new login account within SQL Server for a Windows
2000 group. You want the members of this group to be able to use SQL Server.
What additional security tasks must you perform?
Answer
You must add the Windows 2000 group to the database to which you want the users
to access, and then grant permissions on the database objects to which you want
the users to access. You want to view metadata about objects in a SQL Server
database. What methods would you use?
Answer
You could query the information schema views, execute system stored procedures,
or use system functions. You also could query the system tables directly, but
it is not advised because they may change in subsequent product versions.
You want to reference two tables that reside in different databases on the
same server. From the Inventory database, you want to reference a table in the
Sales database. How would you reference the table in the Sales database in a
query?
Answer
You would reference the table in the Sales database by using a fully qualified
name. For example, you could specify Sales.dbo.tablename or Sales.. tablename.
Saurabh Rajderkar.
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
