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
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What is the current limitation of the size of SQL Azure DB?
What is log ldf?
How does Report Builder support Analysis Services cubes?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Can we insert data into view sql server?
What is read uncmmited?
List all types of constraints in sql server?
While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?
How can we get count of the number of records in a table?
How you can minimize the deadlock situation?
How to find the second highest salary of an employee?
Write an sql query to find first weekday of the month?
What do you know about normalization and de- normalization?
What is the difference between the application object and session object?