Midhun C N
  • Member for 6 years, 3 months
  • Last seen this week
  • Chennai, India
1 answers
1 votes
3k views
Can't do a full backup because the log is full
Accepted answer
3 votes

I assume you don't have space in your drives to take a log backup. You can use the following query to trick SQL server into thinking that you are actually saving the log backup to disk, But you're not....

View answer
3 answers
4 votes
154 views
VLDB is stuck in recovery state. It's a permission issue, now what should I do?
2 votes

SQL server service account does not have permission to access the file. Navigate to the folder in which this file is residing Grant Full control privilege on this folder to the SQL server service ...

View answer
3 answers
4 votes
42k views
How to send email from SQL Jobs in SQL Server 2014
2 votes

First Setup a Database Mail account, Database Mail profile and use the below code in your SP. EXEC msdb.dbo.sp_send_dbmail @profile_name='Mymail', @recipients='MYmail@company.com', @subject = '...

View answer
3 answers
-1 votes
109 views
What version of SQL Server do I need for practice?
1 votes

If you don't plan on installing SQL server multiples times or in multiple VM's to practice or test the High availability features. SQL server Express edition will do just fine, And it's free too.

View answer
3 answers
11 votes
2k views
DROP USER takes too long when there are many users
0 votes

A cursor similar to this should work Use DB_name declare @username varchar(50) declare user_cursor cursor for select '['+name+']' from sys.database_principals where type in ('u', 's') and ...

View answer