Interested to Buy Any Domain ? << Click Here >> for more details...
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
Determine how to use the inserted and deleted pseudo tables?
Write a query to find 5th highest amount paid from the customer table.
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How to create a simple user defined function in ms sql server?
Will count(column) include columns with null values in its count?
What are dml (data manipulation language) statements in ms sql server?
How to remove duplicate rows from table?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
How do you drop an index?
Explain the different types of joins?
What is blocking and how would you troubleshoot it? : sql server database administration
Where cross join is used?
What is always encrypted?
What is normalization 1nf 2nf 3nf?
How to verify a login name with sqlcmd tool?
