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
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
How do I setup a local sql server database?
Where are stored procedures in sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is purpose of normalization?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are scalar functions in sql?
What is the process of indexing?
What is the difference between a check constraint and a rule?
How you can move data or databases between servers and databases in sql server?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What is the difference between varchar and varchar types?
What is master database? : SQL Server Architecture
How can you insert null values in a column while inserting the data?
Describe the left outer join & right outer join. : sql server database administration