Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain sp_configure commands, set commands?

Answer Posted / senthil ku,mar

Use sp_configure to display or change server-level
settings. To change database-level settings, use ALTER
DATABASE. To change settings that affect only the current
user session, use the SET statement

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between indexing and hashing?

1169


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071


What is difference between joins and subqueries?

1120


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2485


What is the use of group by clause?

943


What do you understand by hotfixes and patches in sql server?

991


How will you add a dimension to cube? : sql server analysis services, ssas

1086


What is table value parameters (tvp)?

1101


What is optimization and its types?

982


What is difference between order by and group by?

1007


What command would you use to create an index?

1056


What is similarity and difference between truncate and delete in sql?

1102


Differentiate sql server reporting services vs. Crystal reports?

201


Explain syntax for viewing trigger?

928


How to run sql server 2005 books online on your local system?

961