|
No, if someone is using the databse then the datbase can't be renamed . For renaming the database we....
|
|
|
|
sp_rename 'olddatabasename' 'newdatbasename'
|
|
|
|
No,it is not possible . Because according to refrential integrity the table with the foreign can not....
|
|
|
|
DBCC SHOW_STATISTICS is the command used for displaying the current distribution statistics. Synatx:....
|
|
|
|
This command is used when we are dealing with large amount of data, i.e. when deletion or copying of....
|
|