Viewing 7 posts - 1 through 7 (of 7 total)
You can install SQL Server on a computer that is already running instances of an earlier SQL Server version. If a default instance already exists on the computer, SQL Server...
May 25, 2016 at 11:02 pm
Backup .. Restore will be the best option in this case. It won't impact the incoming i/os to the procduction DB unless you are hosting the duplicate db on the...
May 25, 2016 at 10:49 pm
it is possible to give execute permissions without write permissions. But If the stored procedure includes insert\update statements, the user can insert\update the table by calling the stored procedure.
Even if...
May 24, 2016 at 10:53 am
As all the files are on primary file group, you can empty the below files using the command DBCC SHRINKFILE ('filename',EMPTYFILE) and remove the files using alter database remove...
May 24, 2016 at 10:32 am
Check the tablesizes on that database periodically and check is there any tables are growing abnormally.
May 23, 2016 at 10:52 am
You can remove the secondary datafiles using the below commands
USE DB1
DBCC SHRINKFILE('filename1', EMPTYFILE);
and then delete the file:
ALTER DATABASE DB1 REMOVE FILE filename1;
May 23, 2016 at 10:29 am
Create a DML trigger and send mail using sp_send_dbmail based on the condition.
July 31, 2013 at 10:25 pm
Viewing 7 posts - 1 through 7 (of 7 total)