How to transfer Logins from SQL Server 2000 to 2005
Answers were Sorted based on User's Feedback
Answer / ravi
we have to run the microsoft standard script or use stored
procedures if less logins are there try to create..........
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sandeep
Taking backup and restore of the system database
Is This Answer Correct ? | 0 Yes | 3 No |
Is trigger fired implicitely?
What is subquery? Explain the properties of a subquery?
What is the maximum number of index per table?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How do you connect 100 files as a flat file sources in one package of SSIS?
List some advantages and disadvantages of stored procedure?
how many non clustered index in sql server 2008,2010,2012
I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.
After removing a table from database, what other related objects have to be dropped explicitly?
How to find index size for each index on table?
What is Check point? Explain in Brief what it will do?
How to skip remaining statements in a loop block using continue statements?