In case there are multiple ldf file in the same drive that you do not want to keep, you can empty the ldf file and remove it. But after remove you will get this error. Msg 5009, Level 16, State 9, Line 1 One or more files listed in the statement could not be found […]
I just realised CTRL + L is not working for Estimated Execution Plan in SQL Server 2012. This is replaced by CTRL + Alt+ Shift + L . Microsoft C’mon!!
The major Issue to work in DMZ zone is unavailability of AD and DNS server. So even you have admin access in both server, it is hard to schedule job to copy SQL files periodically. One way is to work thru’ sql server jobs. Following procedure has to be performed to make it work. Open […]
Yesterday, one of the manager comes to me and ask me if there is way to see all the indexes in the table that has been used and get reports for databases. He is glad after I send him this query which will give all used and unused indexes. declare @dbid int select @dbid = […]
–run the following command in sql server management studio. execute as login= ‘domain\loginName’ –verify the current user in the session select system_user –run the sql query to verify the access select * from sysprocesses –revert the change revert
We all know DBAs are always cool 😛 . This website always contains database fun with lots of very important information which helps DBA to perform different task and troubleshoot. You can always send me feedback and questions to me. – Ashok